+ Reply to Thread
Results 1 to 2 of 2

Gridlines Excel 2013 are suddenly off by default

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Soesterberg, Netherlands
    MS-Off Ver
    2013
    Posts
    2

    Gridlines Excel 2013 are suddenly off by default

    Whenever I create a new Excel file or make a new sheet, there are no gridlines. This suddenly started yesterday. I was working on some macro, but I wasn't doing anything with gridlines. And since there is no default setting for gridlines, I don't see how I could have done anything to get this result.

    The gridline colour is set to automatic. I know that I can turn on gridlines under View, or Options - Advanced. But that only works for the current sheet. Whenever I make another sheet, it will be without gridlines.

    I have found a workaround: Make a Book.xltx and a Sheet.xltx file with gridlines and place them in XLSTART. This works, but it has an undesired side effect: When I copy data and then create a new sheet, I can't paste anymore (the clipboard is emptied when I make a new file or sheet). I can of course first make the sheet and then copy my data, but I often forget.

    Any help is much appreciated.

  2. #2
    Registered User
    Join Date
    12-09-2015
    Location
    Soesterberg, Netherlands
    MS-Off Ver
    2013
    Posts
    2

    Re: Gridlines Excel 2013 are suddenly off by default

    I asked the helpdesk at my work to look at it, they tried to repair Office, but it had no effect. I also have Excel 2010 on my computer, that works without problem. I guess the only remaining option is to re-install the whole thing.

+ 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. I Want Excel 2013 to Open Prior Folder, not Default
    By HelpMeSaveTime in forum Excel General
    Replies: 1
    Last Post: 06-01-2015, 01:01 PM
  2. Replies: 6
    Last Post: 03-19-2015, 04:12 AM
  3. [SOLVED] Excel 2013 Pivot Table - Setting a default value label (MIN, MAX etc)
    By Vanth_2013 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-11-2015, 12:59 PM
  4. How to restore default VBA libraries in Excel 2013?
    By billyandted2 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-22-2014, 12:21 PM
  5. Replies: 0
    Last Post: 07-14-2006, 01:45 PM
  6. [SOLVED] Excel should let me set print gridlines as a default
    By Peg B in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-15-2006, 06:25 PM
  7. [SOLVED] Can I set gridlines in excel as a default setting? How?
    By JES in forum Excel General
    Replies: 7
    Last Post: 01-03-2006, 05:40 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