ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hide worksheet parts (https://www.excelbanter.com/excel-discussion-misc-queries/172076-hide-worksheet-parts.html)

Cooz

hide worksheet parts
 
Hi everyone,

I have seen Excel 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 - they all form
just one big gray area.

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

Thank you,

Cooz

Bob Phillips

hide worksheet parts
 
ToolsOptionsView, uncheck row and column headers.

To hide rows and/or columns, select the rows say, and then goto
FormatRowsHide

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Cooz" wrote in message
...
Hi everyone,

I have seen Excel 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 - they all form
just one big gray area.

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

Thank you,

Cooz




David Biddulph[_2_]

hide worksheet parts
 
See the replies to your message of 4 minutes earlier.
--
David Biddulph

"Cooz" wrote in message
...
Hi everyone,

I have seen Excel 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 - they all form
just one big gray area.

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

Thank you,

Cooz





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com