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 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: Go to the Layout tab 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


title: “View And Print Gridlines And Headings In Excel 2020 Master” ShowToc: true date: “2022-10-21” author: “Karl Angel”


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 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: Go to the Layout tab 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