Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dawnvt
 
Posts: n/a
Default How do I change worksheet background?

I have tried everything to get the spreadsheet background back to
normal(blank) but it is a mauve color and very annoying...I have tried
background and formating ...I take everything away if its there but the color
stays...
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim M
 
Posts: n/a
Default How do I change worksheet background?

In your 'formatting' toobar have you tried outlining the offending area and
under 'fill color' select 'no fill'

"Dawnvt" wrote:

I have tried everything to get the spreadsheet background back to
normal(blank) but it is a mauve color and very annoying...I have tried
background and formating ...I take everything away if its there but the color
stays...

  #3   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln
 
Posts: n/a
Default How do I change worksheet background?

Click on a cell and then go to Format|Conditional Formatting... and
check for any conditional formats. I'm guessing you have one that sets
cell color to 'mauve' for empty cells.

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dawnvt
 
Posts: n/a
Default How do I change worksheet background?

yes that isn't it
It's the whole file and spreadsheet...but my other files are fine...it has
been this way for a year now...one day it just appeared that way...the file
is shared with accounting (full of bills and numbers...)

"Tim M" wrote:

In your 'formatting' toobar have you tried outlining the offending area and
under 'fill color' select 'no fill'

"Dawnvt" wrote:

I have tried everything to get the spreadsheet background back to
normal(blank) but it is a mauve color and very annoying...I have tried
background and formating ...I take everything away if its there but the color
stays...

  #5   Report Post  
Posted to microsoft.public.excel.misc
Dawnvt
 
Posts: n/a
Default How do I change worksheet background?

that's not it either, no color is set.
the whole file and spreadsheet is mauve with and without data
I can change the format but when I clear that color the default appears to
mauve instead of no color which is preferred...grrrrrr :(

"Mark Lincoln" wrote:

Click on a cell and then go to Format|Conditional Formatting... and
check for any conditional formats. I'm guessing you have one that sets
cell color to 'mauve' for empty cells.




  #6   Report Post  
Posted to microsoft.public.excel.misc
Tim M
 
Posts: n/a
Default How do I change worksheet background?

Can you try to highlight the whole sheet then
'format'....'cells'...'patterns' and see if that is mauve?

"Dawnvt" wrote:

yes that isn't it
It's the whole file and spreadsheet...but my other files are fine...it has
been this way for a year now...one day it just appeared that way...the file
is shared with accounting (full of bills and numbers...)

"Tim M" wrote:

In your 'formatting' toobar have you tried outlining the offending area and
under 'fill color' select 'no fill'

"Dawnvt" wrote:

I have tried everything to get the spreadsheet background back to
normal(blank) but it is a mauve color and very annoying...I have tried
background and formating ...I take everything away if its there but the color
stays...

  #7   Report Post  
Posted to microsoft.public.excel.misc
CBrausa
 
Posts: n/a
Default How do I change worksheet background?


Have you checked under Tools, Options, Color tab and make sure it's set
on black & white?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=539958

  #8   Report Post  
Posted to microsoft.public.excel.misc
Dawnvt
 
Posts: n/a
Default How do I change worksheet background?

it was set for Black but I clicked on the reset button and that cleared it
Thank YOu soooooo much!!!!
:)

"CBrausa" wrote:


Have you checked under Tools, Options, Color tab and make sure it's set
on black & white?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=539958


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
Worksheet change with pivot table Richard Excel Discussion (Misc queries) 3 February 20th 06 11:20 PM
Worksheet Change event DoctorG Excel Discussion (Misc queries) 4 February 15th 06 01:53 PM
Use "PROPER" to change UPPERCASE text to Title Case on worksheet cmurdock Excel Worksheet Functions 1 February 1st 06 12:19 AM
How do I change the number of columns and rows in a worksheet SteveK Excel Discussion (Misc queries) 2 October 27th 05 04:13 AM
Change of text or background color doesn't change on the screen. Susan Excel Discussion (Misc queries) 5 July 29th 05 08:18 PM


All times are GMT +1. The time now is 05:28 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"