Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

View and Print Gridlines and Headings in Sheet Options-Excel

Posted on 29/06/201930/06/2022 by DigiRuns

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 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.
See also  How to Split Text to Columns in Excel - 2022

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.
See also  [Fixed] Excel is Not Recognizing Numbers in Cells - 2022

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 not 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.
See also  Ways to Apply Accounting Number Format in Excel - 2022

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:

Recent Posts

  • How to Hide Featured Image On a WordPress Post/Page – 2022
  • YouTube Floating Window for Windows, Mac, and Mobiles
  • A Table Generator for Word and Office 360 – Shortcut Trick
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Select Objects That are Behind Text in Word – 2022