How to Print the Gridlines in Excel
By default, the gridlines in Excel are not printed when you print a worksheet. But if you want the gridlines to be printed, follow the below steps :
Step 1: Go to the Page Layout tab in Exel
Step 2: Find the Gridlines section and check the Print Checkbox
In the Sheet Options group, find the Gridlines section and check the Print Checkbox
Step 3: Now the Gridlines will be Printed on Printing the Worksheet
Note: Gridlines are not printed by default, borders around cells are always printed, and cell borders can be used as an alternative if you want the visible lines in your printed documents.
How to Remove Grid lines in Excel
When you open the Excel sheet, you see a cross-section of rows and columns with grey-coloured lines that separate cells. Those gray-colored lines are known as gridlines in MS Excel. The grey color is the default color offered by Microsoft and one can change the color of the gridlines. These Guidelines can be helpful in reading data, but they might become distracting or undesirable when presenting or printing the final document.
Borders and Gridlines are two things that create confusion among users, Borders are customizable and one can change their color, type, and 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.
Contact Us