Excel Gridlines - Hate them? - AdvantEdge Training & Consulting

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 check mark, located on the View tab in the Show Excel GridlinesSetup 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.Excel Gridlines
    • 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.Excel Gridlines

    (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.Excel Gridlines

    For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top