View and Print Gridlines and Headings in Sheet Options-Excel

View and Print Gridlines and Headings in Sheet Options-Excel

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 whether the gridlines and headings or not. 

View and Print Gridlines and Headings in Sheet Options-Excel
View and Print Gridlines and Headings 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.

Print Gridlines in Excel:

 Print  Gridlines option helps you print or no print 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 Print under gridlines in the Sheet Options group to Check or Uncheck it for print or no print the gridline of a worksheet.
  3. To see the print preview after the check or uncheck the gridline print option, click the print pane option
  4. Then click on the Print Preview.

View Headings in MS-Excel:

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:

  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 Headings of a worksheet.

Print Headings in MS-Excel:

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

  1. Go to the Layout tab
  2. Click on the Print under Heading in the Sheet options group to Check or Uncheck it for print or no print the gridline of a worksheet.
  3. To see the print preview after the check or uncheck the Heading print option, click the print pane option
  4. Then click on the Print Preview.

Other Related Posts: