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

Excel Spreadsheet

ResolvedVersion 2003

Mon 4 Apr 2011, 16:56 Delegate 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

Tue 5 Apr 2011, 13:49 Trainer 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

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips