excel

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

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

Excel

resolvedResolved · Low Priority · Version 2003

nicola has attended:
Excel Introduction course

Excel

How do I wrap text in cells?

RE: excel

Hello Nicola

Thank you for your question and welcome to the forum.

There are a couple of different ways of wrapping text in cells.

You can wrap text as you type, by holding down the Alt key and pressing Enter when you would like to make a new line in the cell you're typing into.

Otherwise, select the cell you'd like to wrap text in, then right-click on it and select Format Cells. Select Alignment, and tick the Wrap Text checkbox, then click OK. You may then need to adjust the column width/row height to make the text wrap how you would like.

I hope this helps.


Kind regards
Amanda

Wed 3 Jun 2009: Automatically marked as resolved.

 

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:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips


Server loaded in 0.08 secs.