Hi,

I have a rather vexing, though small, problem with Excel. I'm creating
worksheets that deal with museum specimens, and the cells in these sheets
tend to contain either a lot of information or none at all.
My problem: I want to be able to see the blank cells when I'm viewing the
sheet, and the cells with text in them automatically obscure the blank cells.
In my case, being able to see which cells are blank is almost as important
as seeing the cells containing data. (I know that putting a "space" in the
cell will cause it to display a blank cell, but we don't want to enter a
space in all of the blank cells--there are too many of them.)
Is there any solution to this? I've tried searching MS Office Help, with no
results, and all of my manipulations of cell/sheet settings don't help. Any
assistance will be much appreciated!

Thanks!

One way:

Select your range. Choose Format/Cells/Alignment and click the Wrap Text
box. You may need to reset your row heights.


Another:

Select your range of data. Choose Edit/Goto/Special and select the Blank
radio button. Click OK.

Press the space bar and type CTRL-Enter. This will put a space in each
blank cell.

In article ,
"botany_girl" wrote:

I have a rather vexing, though small, problem with Excel. I'm creating
worksheets that deal with museum specimens, and the cells in these sheets
tend to contain either a lot of information or none at all.
My problem: I want to be able to see the blank cells when I'm viewing the
sheet, and the cells with text in them automatically obscure the blank cells.
In my case, being able to see which cells are blank is almost as important
as seeing the cells containing data. (I know that putting a "space" in the
cell will cause it to display a blank cell, but we don't want to enter a
space in all of the blank cells--there are too many of them.)
Is there any solution to this? I've tried searching MS Office Help, with no
results, and all of my manipulations of cell/sheet settings don't help. Any
assistance will be much appreciated!