LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display empty cells botany_girl Excel Discussion (Misc queries) 1 July 19th 05 05:51 PM
How can I convert empty strings to empty cells? Shane Excel Discussion (Misc queries) 2 July 19th 05 12:10 PM
Cells That Appear Empty? Joohn Calder New Users to Excel 7 July 16th 05 06:40 PM
CountIF cells are not empty Wayne Excel Discussion (Misc queries) 3 January 6th 05 04:44 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"