Excel Gridlines — Hate them?

The light gray Excel gridlines are a normal part of Excel workbooks when opening a new blank workbook. For some, these gridlines are annoying. Unfortunately, there are no default settings for eliminating gridlines in new workbooks. However, there are a couple of different ways to alter gridlines once you have opened a new workbook or are editing an existing workbook.

Using the “Gridlines” command:

This is the quickest way to remove gridlines, without having to go into the settings area, to turn off the gridlines for the active worksheet only.

  • Click the Gridlines radio box to remove the checkmark, located on the View tab in the Show Setup a Personal Template:

    If you want a workbook to open with one or more gridline exempt worksheets, then a template needs to be built, ensuring worksheets do not have gridlines, and requires intentional updating to overwrite the template.

    • Open a new blank workbook in Excel.
    • Create the number of worksheets you want created within the workbook when using the template, by clicking the plus icon next to the worksheet tabs at the bottom.
    • Remove the gridlines from each worksheet, using the step earlier in this post.
    • Click the File tab, then Save As.
    • Click Browse, so the Save As dialog box opens, then select Excel Template from the Save as Type: dropdown list.

    (By default, this will save your template in the Personal section, when creating a new workbook.)

    • Give your new template a name, like Blank with No Gridlines and click Save.
    • Close your new template, so there are no conflicts.
    • Next time you open Excel, click New under the File tab, then select Personal and your new template will appear.

    Want more? Check out our Excel classes in Denver and Phoenix to find out what else Excel can do for you!