ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Gray area of spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/226231-gray-area-spreadsheet.html)

dhstein

Gray area of spreadsheet
 
I'm working on somebody else's spreadsheet and there is an area to the right
starting at column X that is dark gray. I can't change the formatting of it
- so I'm not sure what command created it and how do I remove it. If anyone
knows what I'm talking about and can help, thank you.



T. Valko

Gray area of spreadsheet
 
It sounds like the columns are hidden.

Select the entire sheet by clicking the "button" immediately above row 1 and
to the left of column A. Goto the menu FormatColumnUnhide.

--
Biff
Microsoft Excel MVP


"dhstein" wrote in message
...
I'm working on somebody else's spreadsheet and there is an area to the
right
starting at column X that is dark gray. I can't change the formatting of
it
- so I'm not sure what command created it and how do I remove it. If
anyone
knows what I'm talking about and can help, thank you.





Max

Gray area of spreadsheet
 
You probably shouldn't do anything. Leave it alone. Why do you need to
"remove it"?Suggest you discuss with the source party for the book before
proceeding.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"dhstein" wrote:
I'm working on somebody else's spreadsheet and there is an area to the right
starting at column X that is dark gray. I can't change the formatting of it
- so I'm not sure what command created it and how do I remove it. If anyone
knows what I'm talking about and can help, thank you.



rzink

Gray area of spreadsheet
 
It sounds like the worksheet is in "Page Break View". Try changing your view
to "Normal".

"dhstein" wrote:

I'm working on somebody else's spreadsheet and there is an area to the right
starting at column X that is dark gray. I can't change the formatting of it
- so I'm not sure what command created it and how do I remove it. If anyone
knows what I'm talking about and can help, thank you.




All times are GMT +1. The time now is 06:52 AM.

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