» 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:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Positioning: The Battle for Your Mind
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Windows XP Pocket Reference
- The Guide to Understanding Financial Statements
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
