Open In App

How to Remove Gridlines in Excel?

Improve
Improve
Like Article
Like
Save
Share
Report

When you open the excel sheet, you see a cross-section of rows and columns with grey colored lines. Those gray colored lines are known as gridlines in MS Excel. The gray color is the default color offered by Microsoft and one can change the color of the gridlines. 

Borders and Gridlines are two things that create confusion among users, borders are customizable and one can change their color, type, width but the same is not true for gridlines.  

Note: Gridlines are always applied on the whole worksheet or workbook, you can’t apply it on one cell or a set of cells. In this case, borders are applicable. 

How to Remove Gridlines in Excel?

Removing gridlines will make your excel worksheet look like a blank document  as shown below:

Worksheet without gridlines

Removing Gridlines in Excel:

Follow the below steps to remove gridlines in excel:

Step 1: Go to the Page Layout tab in the ribbon.

Step 2: In Sheet Options, uncheck the View option under Gridlines

Sheet Options in ExcelUncheck Gridlines

You successfully removed the Gridlines from the sheet.

Tip:  When multiple worksheets are selected, (Group) appears in the title bar of the worksheet. If you don’t want to remove gridlines from multiple sheets, click any unselected worksheet. If there is no unselected sheet then right-click the tab of a selected sheet, and then click Ungroup Sheets.

How to show Gridlines in Excel?

Gridlines can be easily shown if removed from the excel worksheet.  All you have to do is to “check” the View option under Gridlines in Page Layout Tab.

Note: While printing the excel sheet gridlines do not print. If you want to print gridlines on the printed page, select the Print check box under Gridlines in Sheet Options Group and Page Layout Tab.


Last Updated : 29 Dec, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads