+ Reply to Thread
Results 1 to 9 of 9

Missing Grid lines

  1. #1
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Missing Grid lines

    Someone sent me an Excel file with the gridlines non-visible. The data has no grid lines. Beside and below the data the gridlines respond to me changing color. I'm using MS Office 365 on Windows 10 - 64 bit. The gridlines are also dots instead of lines.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,327

    Re: Missing Grid lines

    To diagnose this with certainty, please attach your file (see yellow banner at the top of the page). If you have sensitive data you may delete all of the data, since your issue is not related to data.

    Please clarify: You said the gridlines are non-visible, but then you said they are dots. If they are dots they must visible....?

    It is possible to suppress display of gridlines (View > Show Gridlines checkbox) or change the color, but it is not possible to make them dots.

    If cells use a white fill color (or any fill color) you will not see gridlines around that cell.

    If you are seeing dots they are almost certainly borders, not gridlines.

    What is it you want that is different than what you have?

    gridlines.JPG
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Missing Grid lines

    I'll send a file

  4. #4
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Missing Grid lines

    3 tries for a quarter eh?
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,618

    Re: Missing Grid lines

    On the Active sheet the area with no gridlines has white borders & the gridlines for that sheet have been set to black, rather than automatic, which is why you get dotted lines.
    If you want normal gridlines got File, Options, Advanced, scroll down to "Display options for this worksheet" & change the colour to automatic.

  6. #6
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Missing Grid lines

    Thanks goter fixed.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,618

    Re: Missing Grid lines

    Glad to help & thanks for the feedback.

  8. #8
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,327

    Re: Missing Grid lines

    Quote Originally Posted by Rick Ratzlaff View Post
    3 tries for a quarter eh?
    I guess you were successful but here are details:

    The paper clip icon does not work for attachments. To attach a file:

    1. Under the text box where you type your reply click the Go Advanced button.
    2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
    3. Click the Choose File button to select a file to attached.
    4. Click the Upload button to upload the file.
    5. Then click the Close This Window button. Your file is now attached to your post.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,275

    Re: Missing Grid lines

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Missing Grid lines
    By vanrebl in forum Excel General
    Replies: 1
    Last Post: 03-12-2019, 04:15 PM
  2. [SOLVED] Missing all info above the grid box
    By dmkinter in forum Excel General
    Replies: 17
    Last Post: 02-19-2018, 02:18 AM
  3. Cannot get missing grid lines back
    By dcwm in forum Excel General
    Replies: 9
    Last Post: 09-22-2016, 06:41 PM
  4. [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
  5. Grid lines
    By Inventor in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-08-2010, 03:33 PM
  6. [SOLVED] 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] Missing grid lines
    By Fortissima in forum Excel General
    Replies: 1
    Last Post: 04-05-2005, 04:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1