Instructions on how to delete gridlines in Excel

Instructions on how to delete gridlines in Excel. The Excel interface is a spreadsheet with extended rows and columns. Normally in an Excel table presentation, you will want to remove the lines that are outside your worksheet array but don't know how to do it quickly.

The Excel interface is a spreadsheet with extended rows and columns. Normally in an Excel table presentation, you will want to remove the lines that are outside your worksheet array but don't know how to do it quickly. TipsMake.com will guide you how to delete Excel cell lines quickly.

Instructions on how to delete gridlines in Excel Picture 1Instructions on how to delete gridlines in Excel Picture 1

1. Delete a series of gridlines in Excel

Let's take a look at the example below, we have a table occupies some area in the whole Excel worksheet, except the position with the table out, we will delete all open lines outside.

Instructions on how to delete gridlines in Excel Picture 2Instructions on how to delete gridlines in Excel Picture 2

To do that, you can do in the following two ways:

Method 1:

Open the View ribbon on the toolbar, then select to uncheck the Gridlines line in the Show section .

As you can see, when you remove the check marks, the lines that are left out will immediately disappear.

Instructions on how to delete gridlines in Excel Picture 3Instructions on how to delete gridlines in Excel Picture 3

Method 2:

One way to delete the grid lines is to open the File ribbon on the toolbar.

Instructions on how to delete gridlines in Excel Picture 4Instructions on how to delete gridlines in Excel Picture 4

Next you open the Options item in the File list just displayed.

Instructions on how to delete gridlines in Excel Picture 5Instructions on how to delete gridlines in Excel Picture 5

The Excel Options function window pane will open. You click open Advanced section of this function window pane.

Keep scrolling down to search for Display options for this worksheet .

You click to uncheck the box before Show gridlines in this section.

Instructions on how to delete gridlines in Excel Picture 6Instructions on how to delete gridlines in Excel Picture 6

Finally click OK to confirm the changes have been installed. Then all redundant lines of Excel worksheet will be deleted.

Instructions on how to delete gridlines in Excel Picture 7Instructions on how to delete gridlines in Excel Picture 7

2. Delete the grid lines in a certain area

To delete the grid line in a certain area, highlight the area you want to delete the grid line.

Next, open the Home ribbon on the toolbar, click the Shading icon located in the Font section of this ribbon.

Then you select white (or any other color can also create a rectangular array of colors without lines).

Instructions on how to delete gridlines in Excel Picture 8Instructions on how to delete gridlines in Excel Picture 8

The resulting array you selected will be filled with white and no visible gridlines.

Instructions on how to delete gridlines in Excel Picture 9Instructions on how to delete gridlines in Excel Picture 9

To remove the color, restore the grid, highlight the location, click Shading, and select the No Fill line .

Instructions on how to delete gridlines in Excel Picture 10Instructions on how to delete gridlines in Excel Picture 10

Thank you for following the article TipsMake.com's Guide on how to delete gridlines, hope the article has given you all the necessary tips. Wish you can do it successfully.

4 ★ | 1 Vote