wrap text 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 » Wrap Text in Excel

Wrap Text in Excel

resolvedResolved · Medium Priority · Version 2010

Amy has attended:
Project Introduction course
Project Intermediate course

Wrap Text in Excel

In excel, when you wrap text, the cell automatically expands to allow all of the text in the cell to be shown. However, if you then manually change the height of a cell (by using your mouse to hover over the row and clicking/holding and expanding), the wrap text no longer automatically expands in any of the cells across that whole row.

Is there a way to override this so that wrap text can be reinitiated?

For example, I often create budgets in Excel. And generally I get most of the work done and then might realise that it would look better if Column D for example was expanded in width. So I do that manually. But then all of those cells obviously have more space in them, which means that they all now don't need to be as long. Instead of moving the height of all of them manually, I should be able to un-wrap text and then re-wrap text. But because the original change I made was manual, it doesn't seem to want to do this! And when I re-wrap text, it does it, but the second and third lines are not visable on the sheet (unless I manually change the height).

Thanks,
Amy

RE: Wrap Text in Excel

Hi Amy

You're right. Wrapping text in Excel can be tricky!

As you said, after widening a column that contains wrapped text cells there will be extra row space. To make the text fit the row again try double-clicking in the row headings below the row number rather than clicking and dragging upwards.

I might have missunderstood the question so please let me know, thanks

Doug

Doug Dunn
Best STL

Mon 18 Mar 2013: 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:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




View all Excel hints and tips


Server loaded in 0.08 secs.