+ Reply to Thread
Results 1 to 14 of 14

Excel 2008 : Grid lines missing in spreadsheet

  1. #1
    Registered User
    Join Date
    08-27-2011
    Location
    League City, Texas
    MS-Off Ver
    Excel 2008
    Posts
    7

    Excel 2008 : Grid lines missing in spreadsheet

    My Excel (2008 for Mac) spreadsheets have areas where the faint grid lines are missing. How do I get these to show?

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Grid lines missing in spreadsheet

    Tools > Options > View > Gridlines (2003)

    Show Gridlines in Preferences (2008) I think....
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    08-27-2011
    Location
    League City, Texas
    MS-Off Ver
    Excel 2008
    Posts
    7

    Re: Grid lines missing in spreadsheet

    Thanks, but that's not the solution. My cure, so far, is to use the format brush to paint blank cells over the affected ones. That works, but I lose any entries in the cells.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Grid lines missing in spreadsheet

    It it's like Excel on PC, cells must have no fill in order to see the gridlines. Otherwise you need to use borders.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    08-27-2011
    Location
    League City, Texas
    MS-Off Ver
    Excel 2008
    Posts
    7

    Re: Grid lines missing in spreadsheet

    Thanks for helping, but this is not the solution. There is no fill on these cells.

  6. #6
    Registered User
    Join Date
    10-30-2003
    Location
    Dunstable, England
    MS-Off Ver
    2010
    Posts
    69

    Re: Grid lines missing in spreadsheet

    Assuming the Mac version is the same as PC version (looking wise) To view them, On the Ribbon, chose View tab,
    in the Show Group, select the gridline check box.

    To print them, On Page Layout Tab, the little arrow in the Page Setup group will open the Page Set up dialog box. Sheet tab, select, Print check box

  7. #7
    Registered User
    Join Date
    08-27-2011
    Location
    League City, Texas
    MS-Off Ver
    Excel 2008
    Posts
    7

    Re: Grid lines missing in spreadsheet

    Thanks, but apparently the PC and Mac versions have differences. There is a "view" tab, but in the menu thereof there is no "Show" group.

    I've discovered a work-around, however. I can use the Format Brush to paint grid lines from another part of the spreadsheet. So, I guess I am happy, now. But, I still don't understand what made the grid disappear in certain areas in the first place.

  8. #8
    Registered User
    Join Date
    10-30-2003
    Location
    Dunstable, England
    MS-Off Ver
    2010
    Posts
    69

    Re: Grid lines missing in spreadsheet

    Think you must have your borders formatted to white instead of automatic. You might want to checkout the display options for grid lines under the File Tab, Options, Advanced, Display on this sheet

  9. #9
    Registered User
    Join Date
    08-27-2011
    Location
    League City, Texas
    MS-Off Ver
    Excel 2008
    Posts
    7

    Re: Grid lines missing in spreadsheet

    Again, we run into differences between Excel versions. My version -- 2008 for Mac -- doesn't have an "Options" choice under the "File" tab. In any case, I don't believe I'm having a problem with borders. My problem is with the faint grid lines that normally cover every inch of a spreadsheet. I appreciate your interest though; thanks.

  10. #10
    Registered User
    Join Date
    04-02-2013
    Location
    Metairie, LA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Excel 2008 : Grid lines missing in spreadsheet

    This happened to me using Excel 2010 running Windows XP 32-vit on a PC. Not sure if that makes a difference. Gridlines disappeared when I removed some border formatting. This has never happened before in all the years using Excel. To fix I just copied some blank cells with normal faint gridlines and did a paste-special-formatting operation.

  11. #11
    Registered User
    Join Date
    05-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel 2008 : Grid lines missing in spreadsheet

    alsevcik, I had the same problem with Excel 2007. I just now corrected it based on a comment here. I highlighted the cells that had missing gridlines and then selected "no fill" from the fill drop-down. The faint gridlines reappeared in those random cell blocks. Thanks for posting the question that ultimately solved my problem (and hopefully yours.)

  12. #12
    Registered User
    Join Date
    08-27-2011
    Location
    League City, Texas
    MS-Off Ver
    Excel 2008
    Posts
    7

    Re: Excel 2008 : Grid lines missing in spreadsheet

    THAT'S IT!!!
    After 2 years of struggling I now have the answer. Thanks to you.
    Best.
    AL

  13. #13
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Excel 2008 : Grid lines missing in spreadsheet

    Is this not what shg told you two years ago in this same question and you said there was no fill?
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  14. #14
    Registered User
    Join Date
    08-27-2011
    Location
    League City, Texas
    MS-Off Ver
    Excel 2008
    Posts
    7

    Re: Excel 2008 : Grid lines missing in spreadsheet

    Yes it is. The thing is, I had not put a "fill" into any spaces on my spreadsheet, so I thought there wasn't any fill to remove. When I saw your comment recently I decided to give the "no fill" command a try --- and it worked. Wish I had done that 2 years ago, but that's the way it goes.

+ 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