In excel, when the contents of the cell is more then what the cell can hold, if the adjacent cell is empty, the data will spill to the right.
I know there is a way to disable this feature, but can't seem to find it.
Would someone be able to assist. I'm not looking to shrink the text or fit over two lines, just disable this feature.
Thank you
2007-08-02 08:59:34 · 8 answers · asked by Anonymous in Computers & Internet ➔ Software
When you click on format cells. Click on the allignment tab. Under text allignment click on the arrow under the horizontal allignment. In the drop down menu click fill. click okay. This should stop your text from running over. Good Luck.
2007-08-02 09:15:17 · answer #1 · answered by mss b 2 · 2⤊ 0⤋
You have several options:
You can Format/ Column / Autofit to make the width of the columns the same as that of the text.
You can also use Format / Cells...
and turn on "text wrap" under the Alignment tab. That will keep it from going off the column to the right, and will start a new line in the same cell.
However -- if you put something in the column to the right, it will stop showing that text. I suppose if you just want to truncate what you have (...?) that would work.
I hope that helps!
2007-08-06 09:02:13 · answer #2 · answered by k h 1 · 0⤊ 0⤋
Well, you could right click on the cell, go to Format Cells, click the Alignment tab, and select Wrap Text. I'm not sure how to just cut the text off.
2007-08-02 09:11:23 · answer #3 · answered by oj 5 · 0⤊ 0⤋
The last thing you want to do is put a space or ' mark in a cell to keep the text from flowing over it. This will cause problems in many ways.
Just make the cell the correct width as recommended.
2007-08-03 01:59:47 · answer #4 · answered by vbmica 7 · 0⤊ 1⤋
Didn't know it's possible to disable that...
the one way is to go to Format -> Cells and select "wrap text" in the alignment tab
the bootleg way is to go to the adjacent cell and hit space
2007-08-02 09:08:01 · answer #5 · answered by jimbobbighouse 4 · 1⤊ 1⤋
make the cell bigger
in between the column headers (A, B, C, etc) click and drag or double click to automatically make the cell the right size
2007-08-02 09:10:59 · answer #6 · answered by garpit c 5 · 0⤊ 0⤋
Okay. You gonna hate me for this. For each customer, create a fake =sum() covering all the rows relevent to his. Go to Data>Group and Outline>AutoOutline. Now you can collapse and expand at will by customers. Try not to hide rows. It only mess up your spreadsheet when copy and paste is applied in correctly.
2016-05-21 02:46:33 · answer #7 · answered by ? 3 · 0⤊ 0⤋
Just put a ' mark in the cell to the right of your data cell.
(Apostrophe)
Then your entry gets limited to that particular cell.
2007-08-02 09:12:23 · answer #8 · answered by voyager 6 · 0⤊ 1⤋