#1   Report Post  
Posted to microsoft.public.excel.misc
JMay
 
Posts: n/a
Default 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,


  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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,



  #3   Report Post  
Posted to microsoft.public.excel.misc
JMay
 
Posts: n/a
Default 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,


  #4   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default 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,


Reply
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
lock tab in sheet 2 until cell in sheet one is completed john tempest Excel Worksheet Functions 7 November 24th 05 08:45 AM
How to get a row consecutive from a sheet to another rodante Excel Worksheet Functions 4 October 30th 05 06:20 PM
custom function not recalcing on sheet with outline view donh Excel Worksheet Functions 2 October 25th 05 01:20 AM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
How to save a custom header/footer on ea. sheet of a workbook? auditthis Excel Worksheet Functions 0 August 12th 05 04:49 PM


All times are GMT +1. The time now is 09:42 AM.

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

About Us

"It's about Microsoft Excel"