Preventing Text from Spilling Over
Cellnut wrote on December 31, 1969 18:00 EST |
Tried this shortcut in Excel 2003.
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! |
No sense in article "Preventing Text from Spilling Over "
Piyush Kumar Sharma wrote on December 31, 1969 18:00 EST |
| 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 wrote on December 31, 1969 18:00 EST |
| 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 wrote on December 31, 1969 18:00 EST |
| 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 wrote on December 31, 1969 18:00 EST |
| Using xp2002, no results with above stratogy |
it dosn't work
Jilpatrick wrote on December 31, 1969 18:00 EST |
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 wrote on December 31, 1969 18:00 EST |
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 wrote on December 31, 1969 18:00 EST |
| It works as stated. Good tip. |
This tip is useless
Joy wrote on December 31, 1969 18:00 EST |
| 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 wrote on December 31, 1969 18:00 EST |
| 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 wrote on December 31, 1969 18:00 EST |
nothing happens to the cells after following as per instructions
the better way is to merge cell on write in all the cell |
Microsoft Office XP Step-By-Step (With CD-ROM)
