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.

    For more ways to make Excel work for you, take a live or online training course from Mission Critical Training!