+ Reply to Thread
Results 1 to 3 of 3

Missing Gridlines

  1. #1
    Registered User
    Join Date
    09-20-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    13

    Post Missing Gridlines

    Hi All,

    I understand to Hide/Show gridlines is to go to:
    Tools> Options> View> Under the windows options> Uncheck/check Gridlines

    However in this case, after receiving the file from a colleague, the border lines are still there however, the gridlines has disappear.
    I've checked for the gridline colours to be Automatic rather than white, but its still invalid.

    Any other options?

    Attached is the file for you guys to play around.

    thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Missing Gridlines

    Thats becuase the 'Cell fill' colour is white rather than 'No fill'.

    - Switch it to 'No fill'
    - Then show 'gridlines'

    See attached
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    09-20-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Missing Gridlines

    Tsk tsk tsk,

    disappointment on my side. hahah!

    Thanks Ace!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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