View Single Post
  #1   Report Post  
botany_girl
 
Posts: n/a
Default Display empty cells

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!