Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel spreadsheet

ResolvedVersion 2003

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

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 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.