» 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:
- East of Eden (Oprah's Book Club)
- Excel 2002 For Dummies®
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Getting to Yes: Negotiating Agreement Without Giving In
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
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
