grey cells that should not be

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: grey cells that should not be

  1. #1
    Board Regular
    Join Date
    Dec 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    A fellow worker had a sheet of his excel workbook turn a majority of the cells grey, however when I go to format the colour to no colour, it already has no colour. If I copy and paste the sheet else where than the grey colour background is removed.
    There are no macros in the background, and the sheet may be protected.

    Any ideas?

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,157
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    check for conditional formats...

  3. #3
    Board Regular
    Join Date
    Dec 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When I check conditional formats the pattern colour is black not grey. I turned it to grey and chose the work area range. Yet it did nothing. When I look at the sheet the Whole sheet is grey except for a area that has a boarder around it and large writting PAGE 1 in a light grey written diagonally across it.

    Any other ideas?

  4. #4
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Also, check in Tools/Option, Color tab and see if anyone has modified the white color (the bottom-right box in the "Standard Colors" section should be pure white) and then formatted the cells white (or any other color). If modified, click the "Reset" button on the Color tab; if formatted, reset to "no color".
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  5. #5
    Board Regular
    Join Date
    Dec 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Turns out is was on the print preview I think, after he go out of it the text in the cells disappeared yet they remained in the formula bar. Luckliy when I copy and pasted to another sheet it did not have the grey and was workable, so thanks everyone for helping but I wont waste any more time on it yet it will probably naw at me subcociously.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I presume you mean he was in Page Break Preview. See the View menu.

  7. #7
    New Member
    Join Date
    Sep 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: grey cells that should not be

      
    Actually, he did mean print preview.

    The same thing just happened to me and it was because the spreadsheet actually opened in print preview mode, although it wasn't in the standard print preview box, so I had no visual evidence suggesting that was the problem. This post helped me recognize that and when I selected File/Print Preview, the mode shut off.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com