+ Reply to Thread
Results 1 to 10 of 10

Cannot get missing grid lines back

  1. #1
    Registered User
    Join Date
    02-14-2010
    Location
    Preston England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Cannot get missing grid lines back

    I have got a block of cells with no grid lines. They do not come up as merged cells. I cannot get the grid lines to re-appear. How to get the grid lines back please ?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,968

    Re: Cannot get missing grid lines back

    Have you set the interior colour of the cells to white? Or any other colour? If you have, you'll need to clear it or use borders instead.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-14-2010
    Location
    Preston England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Cannot get missing grid lines back

    No, they don't seem to be anything different from the neignouring cells and background color = no color

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Cannot get missing grid lines back

    I experience this occasionally when I copy/paste from a website.

    Maybe this...

    Select the range of cells in question
    Goto the Home tab>Editing Group
    Click the Eraser drop down>Clear Formats
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,968

    Re: Cannot get missing grid lines back

    Maybe post a sample workbook that demonstrates the problem.

  6. #6
    Registered User
    Join Date
    02-14-2010
    Location
    Preston England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Cannot get missing grid lines back

    OK Tony, Thank you very much. This worked perfectly. Sorry for the delay in replying, but I was away for a few days.

  7. #7
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Cannot get missing grid lines back

    You're welcome. Thanks for the feedback!

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,968

    Re: Cannot get missing grid lines back

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,968

    Re: Cannot get missing grid lines back

    No, they don't seem to be anything different from the neignouring cells and background color = no color
    I guess that just looking at the cells wasn't enough. Sometimes, if you select a group of cells to check, you get the information relating to one specific cell, not necessarily the one whose format you want to check.

    Glad that Tony could offer a solution.

  10. #10
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Cannot get missing grid lines back

    I don't have to go through the tabs/menus.

    I put the Clear Formats button on my QAT/toolbar so it's just a quick click of a button.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2008 : Grid lines missing in spreadsheet
    By alsevcik in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 13
    Last Post: 12-31-2013, 10:32 AM
  2. Grid lines gone...
    By BobJones in forum Excel General
    Replies: 6
    Last Post: 09-16-2011, 09:37 PM
  3. [SOLVED] Grid Lines
    By DNA in forum Excel General
    Replies: 4
    Last Post: 07-10-2006, 04:29 AM
  4. Missing the grid window on a worksheet
    By mike.welker@gmail.com in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 11:25 AM
  5. Can't get grid lines
    By W. Wells in forum Excel General
    Replies: 5
    Last Post: 03-11-2006, 02:30 PM
  6. Where are my partially missing grid lines?
    By newbie in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 02:05 PM
  7. [SOLVED] Grid Lines
    By Nelson in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2005, 03:06 PM
  8. Missing grid lines
    By Fortissima in forum Excel General
    Replies: 1
    Last Post: 04-05-2005, 04:06 AM

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