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

excel

ResolvedVersion 2003

Rose has attended:
Excel Intermediate course
Project Intro Intermediate course

Excel

How do you add an address on separate lines within one single cell?

RE: Excel - Adding multiple lines within a single cell

Dear Rose

Thank you attending the Excel Intermediate course. I hope you enjoyed the course and found the day to be fruitful.

To force the cursor to blink on the next line on the same cell you have to press ALT+Enter. This is also known as a line break.

It you wish to simply put some text on the separate lines without adjusting the column width you can also use the Wrap text facility which you can find in Format > Cells

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

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.11 secs.