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 whether 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:

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 not 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:

3. Go to the Layout tab
4. 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 not print the Headings in excel when you check or uncheck this option. To do that, follow the steps below:

5. Go to the Layout tab
6. 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.
7. To see the print preview after the check or uncheck the Heading print option, click the print pane option
8. Then click on the Print Preview.

Other Related Posts:

• Introduction and User Interface to MS-Word | All in 1
• Magical Shortcuts and Hidden Secrets in MS-Word
• Difference Between Functions and Formulas in Excel.

FAQ: