» 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:
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Yes, You Can Time the Market!
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Now, Discover Your Strengths
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
