How to Print First Row or Column on Every Excel Page

See more articles by Sandeep →

Supreeth is passionate about technology and dedicates himself to helping people figure it out. An engineer by education, his understanding of the inner workings of all types of gadgets and devices ensures he provides top-notch guidance, tips, and recommendations to his readers. When away from the desk, you will find him traveling, playing FIFA, or hunting for a good movie.

Print the First Row or Column on Every Excel Page

Step 1:On your workbook, select the desired sheet and navigate to thePage Layouttab on the ribbon.

Step 2:Then, click on the icon forPage Titlesunder thePage Setupsection.

Step 3:In thePage Setupmodal window, switch to theSheettab and spot the section forPrint titles. It includes row and column options.

Note:Though we focus on the header row, the setting can also be applied to columns.

Step 4:To set up printing of the top row on each page, click on theArrow up buttonin front of ‘Rows to repeat at top’text box. For columns, take the second one.

Step 5:That will take you to the Excel sheet along with a dialog box. Clickrow number 1(on the sheet) and press thearrow-down buttonin front of it.

Here, you can select multiple rows on each page if you wish to repeat them. Generally, you would want the top row and, in rare circumstances, the leftmost column.

Step 6:Back in the Page Setup modal window, you will see the text boxes populated with the row/column values to repeat on each page. You can choosePrint Previewto ensure the print includes a header or columns on all pages.

In the print preview, check whether the settings work. Note that the settings are sheet-specific and do not apply to the workbook.

If you cannot print, check out the guide onExcel printing fixes.

FAQs

How Do You Print Row and Column Numbers When Printing in Excel?

Sometimes, you also want to print row headings 1, 2, . . . and column headings A, B, . . . To achieve this, navigate toPage Layout>Sheet Optionsand check theRow and column headingsbox in the Printsection.

Why Is Print Titles Button Greyed Out?

If you cannot access thePrint Titlesbutton, it might be because you are editing a cell or have a chart selected. Similarly, if you cannot use the Rows to repeat at the top spreadsheet icon, it could be because you have selected multiple worksheets within your workbook.

Was this helpful?

Last updated on 29 April, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Smart Home

How to Use VLC Media Player on Android TV

5 Ways to Fix Amazon Prime Video Not Working on Apple TV

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.