» Automatically Wrapping Text in a Cell
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
1. Type the following text into a cell: "This is the best ExcelTip book".
2. Press Ctrl+1, and select the Alignment tab.
3. Select the Wrap text checkbox.
4. Click OK.
Book Store:
Recommended Books:
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Financial Statement Analysis with S&P insert card
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
Tip not complete
Lori
I don't usually do this, but I take exception with this tip about 'Automatically Wrapping Text.' I don't think the use of the word Automatic is appropriate. I'll give you that it is a nice shortcut though. Also, there is a step missing; 1a. Press Enter. If you hit CTRL+1 before you press enter, you will be formatting only the text, not the cell.
Automatically Wrapping Text in a Cell
nag45
Okay, Is there a way to wrap text in more than one cell in the same coumn. We had a commND IN Lotus123 "/range/justify"
To automatically wrap text:
nag45
Ok.This expands the height of the row to weap the text. Is there a way to wrap the text in more than one row;two or more cells in the same column. We had a commnd in Lotus 123 "/Range/justify"
Automatic wrap text
Cal
Similar result can be obtained by using the Alt and the space key.
Automatically Wrapping Text in a Cell
Simon
The statement automatic is incorrect. This tip only sorts out 1 cell. How do you set wrap text to be permanetly on? This would be better
