» 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:
- Financial Reporting and Analysis (2nd Edition)
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Monte Carlo Methods in Finance
- Special Edition Using Microsoft Word 2002
Canceling automatic text wrap
rob Posted on: 31-12-1969
how do you go about Canceling automatic text wrap?Canceling automatic text wrap
Jim C Posted on: 31-12-1969
Rob,
In the Format Menu, select Format cells (ctrl+1), select the Alignement tab, then uncheck the Wrap text box
Reply: Hiding formula in formula bar - Divyesh Bharucha from India wrote on June 30, 2003 7:56 AM EST
Alan Posted on: 31-12-1969
Hi Divyesh,
This is probably not the answer you are looking for, but I have a personal rule that if my formulae get long enough to bother me in that way, I split it up across multiple cells in a separate calculation area.
Even if you understand it now, I guarantee that you will kick yourself if you have to re-write it in a years time!
Much better to calculate each part of the whole separately, label them neatly in a calculation zone, and keep each formula short in length. The person that inevitably follows you will have some hope of following it too, and won't rubbish your name / reputation quite as badly.
Hope that helps in some way,
Alan.
Forms - wrapping text
Chris Earl Posted on: 31-12-1969
I have created a form with combo boxes, i.e. drop down boxes in two columns. In another column i want the text to wrap automatically so that as you type the cells get bigger - i have clicked on the wrap option in alignement but because of the drop down boxes it isn't working. Any ideas how i can solve this? Cheers, Chris.


1) can i hide this perticular formula in formula bar.
=IF(LEN(H189)=5,IF(ISNA(ABS(VLOOKUP(TEXT(H189,0),data!B$2:E$364,1,FALSE)))=TRUE,0,ABS(VLOOKUP(TEXT(H189,0),data!B$2:E$364,4,TRUE))),IF(LEN(H189)=11,(IF(ISNA(ABS(VLOOKUP(LEFT(TEXT(H189,0),5),data!B$2:E$364,1,FALSE)))=TRUE,0,ABS(VLOOKUP(LEFT(TEXT(H189,0),5),data!B$2:E$364,4,TRUE)))+IF(ISNA(ABS(VLOOKUP(RIGHT(TEXT(H189,0),5),data!B$2:E$364,1,FALSE)))=TRUE,0,ABS(VLOOKUP(RIGHT(TEXT(H189,0),5),data!B$2:E$364,4,TRUE)))),IF(LEN(H189)=17,(IF(ISNA(ABS(VLOOKUP(LEFT(H189,5),data!B$2:E$364,1,FALSE)))=TRUE,0,ABS(VLOOKUP(LEFT(H189,5),data!B$2:E$364,4,TRUE)))+IF(ISNA(ABS(VLOOKUP(MID(H189,7,5),data!B$2:E$364,1,FALSE)))=TRUE,0,ABS(VLOOKUP(MID(H189,7,5),data!B$2:E$364,4,TRUE)))+IF(ISNA(ABS(VLOOKUP(RIGHT(H189,5),data!B$2:E$364,1,FALSE)))=TRUE,0,ABS(VLOOKUP(RIGHT(H189,5),data!B$2:E$364,4,TRUE)))),1)))