» 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 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- PowerPoint® 2002 For Dummies®
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- The New Financial Order: Risk in the Twenty-First Century
- How to Use Financial Statements: A Guide to Understanding the Numbers
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
