View and Print Gridlines and Headings in Sheet Options-Excel

This gridline is used to boldly change the vertical and horizontal lines of cells in the block of the selected worksheet to view or print.

In this article, you can learn how to View and Print Gridlines and Headings in Excel. These options are especially useful when you print the worksheet using the gridlines, headings or not. 

View and Print Gridlines and Headings in Sheet Options-Excel
View and Print Gridlines and Headings in Excel​

View Gridlines in Excel:

View Gridline helps you see or remove the gridline in excel when you check or uncheck the option. To do that, follow the steps below:

  1. Go to the Layout tab
  2. Click on the View in the sheet options group to Check or Uncheck it for view or remove the gridlines of a worksheet.

 The print Gridlines option helps you print or not print the gridline in excel when you check or uncheck the option. To do that, follow the steps below:

Go to the Layout tab

Click on the Print under gridlines in the Sheet Options group to Check or Uncheck it for print or no print the gridline of a worksheet.

To see the print preview after the check or uncheck the gridline print option, click the print pane option

Then click on the Print Preview.

View Headings in MS Excel:

The View Gridline option helps you see or remove the gridline in excel when you check or uncheck this option. To do that, follow the steps below:

Go to the Layout tab

Click on the View in the sheet options group to Check or Uncheck it for view or remove the Headings of a worksheet.

The print Headings option helps you print or not print the Headings in excel when you check or uncheck this option. To do that, follow the steps below:

Go to the Layout tab

Click on Print under Heading in the Sheet Options group to Check or Uncheck it for print or no print on the gridline of a worksheet.

To see the print preview after the check or uncheck the Heading print option, click the print pane option

Then click on the Print Preview.

Video Tutorial

Why do we use gridline?

Gridline is used to boldly change the vertical and horizontal lines of cells in the block of the selected worksheet to view or print.

Share