ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom Sheet Look (https://www.excelbanter.com/excel-discussion-misc-queries/58715-custom-sheet-look.html)

JMay

Custom Sheet Look
 
I just came across a simple excel file on my PC
that shows only the spreadsheet (Sheet1) from
A1:G25 (Normal White area, with grid lines).
The remainder on the screen is dark gray.
How is this acheived? I can't seem to find
the settings that are producing this view.
TIA,



Gary''s Student

Custom Sheet Look
 
Just hide all columns past G and all rows below 25
--
Gary's Student


"JMay" wrote:

I just came across a simple excel file on my PC
that shows only the spreadsheet (Sheet1) from
A1:G25 (Normal White area, with grid lines).
The remainder on the screen is dark gray.
How is this acheived? I can't seem to find
the settings that are producing this view.
TIA,




JMay

Custom Sheet Look
 
Thanks Roger,
yeah, that's it; seems simple enough,,
Jim

"Roger Govier" wrote in message
...
Hi

Mark columns H:IV FormatColumnsHide

Regards

Roger Govier


JMay wrote:
I just came across a simple excel file on my PC
that shows only the spreadsheet (Sheet1) from
A1:G25 (Normal White area, with grid lines).
The remainder on the screen is dark gray.
How is this acheived? I can't seem to find
the settings that are producing this view.
TIA,



Roger Govier

Custom Sheet Look
 
Hi

Mark columns H:IV FormatColumnsHide

Regards

Roger Govier


JMay wrote:
I just came across a simple excel file on my PC
that shows only the spreadsheet (Sheet1) from
A1:G25 (Normal White area, with grid lines).
The remainder on the screen is dark gray.
How is this acheived? I can't seem to find
the settings that are producing this view.
TIA,




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

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