Results 1 to 3 of 3

Thread: How to restore cell gridlines lost after coloring the cell in Excel?

  1. #1
    Join Date
    Nov 2011
    Posts
    61

    How to restore cell gridlines lost after coloring the cell in Excel?

    While working on my Excel worksheet I sometimes color cells. When the cell is returned to white the gridlines for those specific cells are gone. How can I restore them?

  2. #2
    Join Date
    Nov 2010
    Posts
    503

    Re: How to restore cell gridlines lost after coloring the cell in Excel?

    White is a color and it hides the gridlines. Highlight the cells you want to restore grid line after removing the color. On the "Home" tab, click on theme color and select "no fill" (the icon below the standard colour). Unhighlight the cells. Also you can go for None for the same purpose. it is totally dependent on you whether you wanted to use No Fill or none.

  3. #3
    Join Date
    Dec 2010
    Posts
    351

    Re: How to restore cell gridlines lost after coloring the cell in Excel?

    In order to get the requirement of yours you have to use following steps.
    • Click on the Office button and click on Excel Option.
    • Go for Advanced into that look for Display option for worksheet and click on Show gridlines and select a new color. If you don’t wanted to have any gridlines than simply uncheck Show gridlines checkbox.

Similar Threads

  1. How to disable excel for taking empty cell in Excel chart
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 12:30 PM
  2. Applying absolute cell referencing to many cell in Excel
    By Nyota in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 07:23 PM
  3. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 05:00 PM
  4. Unable to find my lost cell phone
    By Zared in forum Portable Devices
    Replies: 5
    Last Post: 09-12-2010, 07:23 AM
  5. Auto-populate a MS Word table cell with text from a diff cell?
    By dreamrthts in forum Windows Software
    Replies: 5
    Last Post: 23-03-2009, 10:39 PM

Tags for this Thread

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
  •  
Page generated in 1,711,676,054.30489 seconds with 17 queries