How to Print Row and Column Heading in Excel

There are times that we want to print those letters and numbers seen in Microsoft Excel Worksheet. So here is an instruction on how to do this things in an easy way,

Row headings are the row numbers to the left of the worksheet; column headings are the letters or numbers that appear at the top of the columns on a worksheet.

1. Click the worksheet.
2. On the File menu, click Page Setup, and then click the Sheet tab.
3. Do one of the following:

How to Hide Print row and column headings ?

* Select the Row and column headings check box, and click Print.

Hide Print row and column labels on every page

To print column labels on every page, under Print titles in the Rows to repeat at top box, enter the rows that contain the column labels, and then click Print.

To print row labels on every page, under Print titles in the Columns to repeat at left box, enter the columns that contain the row labels, and then click Print.

Dexter Panganiban https://techathand.net/about-2/

Dexter is a person who loves technology,new gadget, SEO, Social Media and Christianity. Follow him at twitter via @techathand and add him @ Google+ and contact us at admin@techathand.net

You May Also Like

More From Author

1 Comment

Add yours

+ Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.