ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do I set all my worksheet background colours to white? (https://www.excelbanter.com/new-users-excel/186622-how-do-i-set-all-my-worksheet-background-colours-white.html)

CD

how do I set all my worksheet background colours to white?
 
How can I do this please?
Chris


MartinW

how do I set all my worksheet background colours to white?
 
Hi Chris,

Here's two ways,
ToolsOptionsView tab and uncheck gridlines

or
Ctrl+A to select your entire spreadsheet
then set the fill color to white.

HTH
Martin


"CD" wrote in message
...
How can I do this please?
Chris




MartinW

how do I set all my worksheet background colours to white?
 
I should add that setting your entire worksheet to have a white
fill color is not a good idea, better to just select the area that
you need if you are going to use this method.

HTH
Martin


"MartinW" wrote in message
...
Hi Chris,

Here's two ways,
ToolsOptionsView tab and uncheck gridlines

or
Ctrl+A to select your entire spreadsheet
then set the fill color to white.

HTH
Martin


"CD" wrote in message
...
How can I do this please?
Chris







All times are GMT +1. The time now is 05:20 AM.

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