+ Reply to Thread
Results 1 to 8 of 8

How do I change worksheet background?

  1. #1
    Dawnvt
    Guest

    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. #2
    Tim M
    Guest

    RE: 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. #3
    Mark Lincoln
    Guest

    Re: 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. #4
    Dawnvt
    Guest

    RE: 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. #5
    Dawnvt
    Guest

    Re: 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. #6
    Registered User
    Join Date
    06-27-2005
    Posts
    55
    Have you checked under Tools, Options, Color tab and make sure it's set on black & white?

  7. #7
    Tim M
    Guest

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


  8. #8
    Dawnvt
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1