The text in an entire column is not showing up. However, when I select the individual cells, the text is displayed. What happened?? and how do I fix it.
-The color of the text is black and the cell background is white.
-The font size is 10.
-The column is not hidden
-MS Excel 2003.
This is driving me crazy...Thanks for your help.
2007-09-24 05:10:36 · 7 answers · asked by Gotcha 1 in Computers & Internet ➔ Software
The column is wide enough and the text is not wrapped...aaarrrgghhhh
2007-09-24 05:17:51 · update #1
Hi,
the column is to small just select auto size to get it right.
2007-09-24 05:16:47 · answer #1 · answered by Anonymous · 0⤊ 2⤋
It may be due to the cell formatting. Select the column then select:
Format > Cells...
Then select the Number tab and select General and click OK. That may make your text visible.
If the cells are set to a Custom format that is set to three semi-colons in a row:
;;;
The text will appear invisible but will show up in the formula bar.
See the website below to explain the hidden text:
http://exceltips.vitalnews.com/Pages/T0882_Easy_Value_Hiding.html
2007-09-28 04:54:47 · answer #2 · answered by devilishblueyes 7 · 0⤊ 0⤋
go to top of sheet, where the letters are for the columns, go to the right side column, in which the cell you want larger is, the cursor will change from a pointer to a vertical line with left and right arrows coming ffom either side. You can either drag the cell wider or double click and it will adjust width so all the text can be seen.
Click on Help, type "column width" and check the other ways to size cells there.
2007-09-24 05:33:34 · answer #3 · answered by clinky 3 · 0⤊ 2⤋
The cell is too small for the text font size and you also probably have it wrapped in format
Expand that cell large enough to see your format and just simply right click on cell and edit the format to normal
2007-09-24 05:13:34 · answer #4 · answered by Anonymous · 0⤊ 2⤋
Your text may be indented inside the cell go to alignment and reset the horizontal alignment to General if it is set to something else
2016-04-26 09:58:50 · answer #5 · answered by jenny 1 · 0⤊ 0⤋
You can try making that column wider. Sometimes when it doesn't really fit it will go blank on you. Doesn't hurt to try. Hope you figure it out.
2007-09-24 05:15:35 · answer #6 · answered by your1starr 2 · 0⤊ 2⤋
yes custom format the cell with the number format you want and then add ' Years' or whatever your want shown after the number.
2016-05-17 09:56:26 · answer #7 · answered by briana 3 · 0⤊ 0⤋