Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
CD CD is offline
external usenet poster
 
Posts: 10
Default how do I set all my worksheet background colours to white?

How can I do this please?
Chris

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 860
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 860
Default 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





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
Data labels print with white background [email protected] Charts and Charting in Excel 2 May 7th 08 12:57 PM
Can a color background on the screen be made to print white on pap Roger Deschenes[_2_] Excel Discussion (Misc queries) 1 July 19th 07 03:28 PM
Background colours whatzzup Excel Discussion (Misc queries) 0 February 12th 07 02:38 PM
Row background colours dramajuana Excel Discussion (Misc queries) 6 June 11th 06 01:15 AM
black background with white spots in the texture steve Excel Discussion (Misc queries) 0 August 6th 05 01:36 AM


All times are GMT +1. The time now is 03:15 AM.

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

About Us

"It's about Microsoft Excel"