How to Remove Gridlines in Excel

Here’s how to remove gridlines in Excel, with visuals for clarity:

Method 1: Using the View Tab

  1. Click the “View” tab.
    Image of Excel ribbon with the View tab highlighted
  2. Uncheck the “Gridlines” box in the “Show” group.
    Image of Show group on the View tab, with the Gridlines checkbox unchecked

Method 2: Using the Page Layout Tab

  1. Click the “Page Layout” tab.
    Image of Excel ribbon with the Page Layout tab highlighted
  2. In the “Sheet Options” group, uncheck the “Gridlines” box under “Print.”
    Image of Sheet Options group on the Page Layout tab, with the Gridlines checkbox unchecked under Print

Method 3: Using the Keyboard Shortcut

  1. Press Ctrl + Shift + 8.

Additional Notes:

  • Removing gridlines only affects the current worksheet’s visual appearance. They will still be visible when printed unless you uncheck the “Gridlines” box under “Print” in the “Page Layout” tab.
  • To remove gridlines from multiple worksheets at once:
    1. Select all the desired worksheets by holding Ctrl and clicking their tabs.
    2. Use any of the methods described above.
  • To completely hide gridlines from view and printing:
    1. Go to File > Options > Advanced.
    2. Under “Display options for this worksheet,” uncheck the “Show gridlines” box.

Leave a Reply