Excel shortcuts

Removing Gridlines in Excel: A Step-by-Step Guide

Gridlines are the horizontal and vertical lines that appear by default on an Excel worksheet. They help you align data on the worksheet, but sometimes they can be distracting. If you want to get rid of the gridlines on your Excel worksheet, here's a step-by-step guide on how to do it.

1. Open your Excel workbook and go to the worksheet on which you want to remove the gridlines.

2. On the Ribbon, click the View tab.

3. In the Show group, uncheck the Gridlines checkbox.

4. The gridlines will disappear from your worksheet.

If you want to get rid of the gridlines on all worksheets in your workbook, you can do that too. Here's how:

1. Open your Excel workbook and go to the first worksheet.

2. On the Ribbon, click the View tab.

3. In the Show group, uncheck the Gridlines checkbox.

4. Click the Sheet tab for the next worksheet. The Sheet tab is located at the bottom of the workbook window, to the left of the worksheet name.

5. Repeat steps 3 and 4 for each worksheet in the workbook.

When you're finished, the gridlines will be gone from all worksheets in your workbook.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.