View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default hiding parts of a worksheet

Click ToolsOptionsView tab, uncheck "Row & Column headers"

If you select all cells (Ctrl-A) right-click and choose "Hide" you
will get the gray condition you are looking for.


HTH,
JP


On Jan 8, 6:55*am, Cooz wrote:
Hi everyone,

I have seen worksheets on which:
- the column header row (A, B, ...) is not visible;
- the row numbers are not visible;
- individual cells are both not visible and not accessible - there is only
one big gray area.

How can this be accomplished? Easy question for all Excel cracks I suppose -
but I just don't know how to do it.

Thank you,

Cooz