» Preventing Text from Spilling Over
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To prevent text from extending beyond the report width:
1. First, ensure that the typed text was only entered into cell A59.
2. Select cells A59:D59.
3. From the Edit menu, select Fill and then Justify.
4. Click OK. The following message appears: Text will extend below selected range. (Before clicking OK, ensure that the cells below row 60 are empty.)
Book Store:
Recommended Books:
- Business Analysis with Microsoft Excel (2nd Edition)
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Now, Discover Your Strengths
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No sense in article "Preventing Text from Spilling Over "
Piyush Kumar Sharma
There is no sense in what is written in article "Preventing Text from Spilling Over "...I tried to do it, but nothing happened
It works in Excel 2003
asleep
Edit > Fill > Justify does work as described in Excel 2003. There is no Edit > Fill > Format option, at least in my version of Excel.
Preventing Text from Spilling Over -try this
jwanegar
Try this: with your cell selected: Format, Cells, Alignment, Wrap Text. Then be sure you adjust the row height if needed.
no results when trying this
jrick
Using xp2002, no results with above stratogy
it dosn't work
Jilpatrick
i applied the below steps but no result
To prevent text from extending beyond the report width:
1. First, ensure that the typed text was only entered into cell A59.
2. Select cells A59:D59.
3. From the Edit menu, select Fill and then Justify.
4. Click OK. The following message appears: Text will extend below selected range. (Before clicking OK, ensure that the cells below row 60 are empty.
Seems useless
HALinNY
if your text exceeds the limits of the print area, you probably want to increase the size of the print area.
This is a nice feature but it's interesting that in 18 years of using Excel, I've never had the need for this. There are simply better ways to achieve the same results.
It works
Nagarajan
It works as stated. Good tip.
This tip is useless
Joy
First of all, when wanting to prevent spilling over, the idea is not to send the text over to a new cell in the next row. The idea is to have the text automatically stop within the cell border. This way, the user has to augment the cell width in order to see the entire content.
Preventing text over spill
IE
It does not work on Excell 2000. Evidently it does on 2003. However, there is a simpler way.
tip will not work in excel 2000
bilal dadan
nothing happens to the cells after following as per instructions
the better way is to merge cell on write in all the cell
Highlighting A59:D59 and then Edit - Fill and Format does not bring up the message box as indicated in the instructions, so doe not keep the text in Column A.
Highlightiong A59 and then Edit-Fill-Format achieves the result I think was sought.
Perhaps them author should specify which Excel version these instructions were worked out on!