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. |
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. |
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. |
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