Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Spreadsheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel Spreadsheet

Resolved · Urgent Priority · Version 2003

Reply Mon 4 Apr 2011, 16:56Delegate Ksenia said...

Ksenia has attended:
Excel Introduction course

Excel Spreadsheet

How would I separate the text if I need to write an address (without using "wrap text" option) i.e
Address Line1
Address Line 2
Town
Postcode

For upcoming training course dates see: Pricing & availability

Reply Tue 5 Apr 2011, 13:49Trainer Ruth said...

RE: Excel Spreadsheet

Hi Ksenia,

To create multi line text in a cell, position your cursor where you want the break to be and press Alt + Enter.

I hope this helps.

Kind regards,

Ruth

Excel articles

· Advanced Excel Training - takes you to the next level
· How To Create An Excel Formula Using Data From Several Worksheets
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Use Hyperlinks In Excel To Make An Impact
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips