ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sheet Background Color (https://www.excelbanter.com/excel-discussion-misc-queries/156509-sheet-background-color.html)

glenn

Sheet Background Color
 
I've have a file in which the worksheet is completely colored in gray and no
gridlines showing. There is no background color applied that I can find.
The gray is exactly same color as the row and column identifier background
color. How can I remove this color or change the color?
Thank you

Tim879

Sheet Background Color
 
Try this:

select all of the data on the spreadsheet (hit ctrl+a) go to edit -
clear - formats



On Aug 30, 3:14 pm, Glenn wrote:
I've have a file in which the worksheet is completely colored in gray and no
gridlines showing. There is no background color applied that I can find.
The gray is exactly same color as the row and column identifier background
color. How can I remove this color or change the color?
Thank you




Kevin B

Sheet Background Color
 
Click VIEW in the menu and select NORMAL. It sounds like you're in PAGE
BREAK PREVIEW view.
--
Kevin Backmann


"Glenn" wrote:

I've have a file in which the worksheet is completely colored in gray and no
gridlines showing. There is no background color applied that I can find.
The gray is exactly same color as the row and column identifier background
color. How can I remove this color or change the color?
Thank you


glenn

Sheet Background Color
 
Thanks Kevin. That was it. I spent an hour fooling around trying to figure
it out.

"Glenn" wrote:

I've have a file in which the worksheet is completely colored in gray and no
gridlines showing. There is no background color applied that I can find.
The gray is exactly same color as the row and column identifier background
color. How can I remove this color or change the color?
Thank you



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

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