Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding parts of a worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding parts of a worksheet
The first couple can be dealt with by Tools/ Options/ View
Unset "Row and columh headers" -- David Biddulph "Cooz" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding parts of a worksheet part 2
Thank you JP.
This is what I was looking for. Strange though that the hide-functionality has different results, depending on what you do: Select column G and all columns to the right by clicking on G and pressing Ctrl-Shift-Right Arrow. Right click and choose Hide. Works as expected. Now select row 10 and all rows above this row by clicking on 10 and pressing Ctrl-Shift-Up Arrow. Right click and choose Hide. The rows disappear. I would like to have a "window" of cells surrounded on all four sides by gray areas, say for example that the range B3:D7 is visible, and that the rest of the worksheet is gray. Do you - or does anyone- know how to do this? Other question: how do I turn a gray area back into "visible and accessible" (other than pressing Ctrl-Z immediately after creating a gray area)? Thank you, Cooz "JP" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding parts of a worksheet part 2
Hi,
I use this method, grey ageys surrounding data. You just simply fill the cells grey. so for example, you select rows A and B and fill the cells grey etc, just leaving the data area you want. Thanks "Cooz" wrote: Thank you JP. This is what I was looking for. Strange though that the hide-functionality has different results, depending on what you do: Select column G and all columns to the right by clicking on G and pressing Ctrl-Shift-Right Arrow. Right click and choose Hide. Works as expected. Now select row 10 and all rows above this row by clicking on 10 and pressing Ctrl-Shift-Up Arrow. Right click and choose Hide. The rows disappear. I would like to have a "window" of cells surrounded on all four sides by gray areas, say for example that the range B3:D7 is visible, and that the rest of the worksheet is gray. Do you - or does anyone- know how to do this? Other question: how do I turn a gray area back into "visible and accessible" (other than pressing Ctrl-Z immediately after creating a gray area)? Thank you, Cooz "JP" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding parts of a worksheet part 2
Glad to help. I don't know how to make that window you are looking
for, it looks like Excel hides rows & columns differently depending on what you are trying to do. Depending on how you hid the cells, it would either be FormatRowUnhide or FormatColumnUnhide. HTH, JP On Jan 8, 7:47*am, Cooz wrote: I would like to have a "window" of cells surrounded on all four sides by gray areas, say for example that the range B3:D7 is visible, and that the rest of the worksheet is gray. Do you - or does anyone- know how to do this? Other question: how do I turn a gray area back into "visible and accessible" (other than pressing Ctrl-Z immediately after creating a gray area)? Thank you, Cooz "JP" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding number parts by cell formatting | Excel Discussion (Misc queries) | |||
Protecting different parts of a worksheet | Excel Discussion (Misc queries) | |||
hiding parts of a cell | Excel Discussion (Misc queries) | |||
hiding parts of a cell | Excel Discussion (Misc queries) | |||
How to hide parts of worksheet | Excel Discussion (Misc queries) |