Step 2: In the Page Setup dialog box, click the Sheet tab. Step 3: In the Print Titles section, click the Browser button to specify the title (top row). Step 4: Click OK button. Now the title (top row) will be printed on every overflowed page. By the way, if you need to prin...
How to Print the Top Row on Every Page in ExcelSuppose you have a dataset as shown below.If you print this data, it would take up multiple pages, but the heading will only appear on the first page.Below are the steps to make sure that the header row repeats on every page that is ...
In the example picture below, for example, I am repeating row “1.” Step 5: Click the “OK” button at the bottom of the pop-up window to apply your changes. Now that you know how to print the top row on every page in Excel you will be able to make it much easier for people...
Step 4:Under the Print Titles section, click on the Rows to repeat at the top option. Then, select row 1 by clicking on the row number. Press Enter to confirm. To check if row 1 is correctly set to print on every page, Press Ctrl+P to quickly open the Print Preview window. Your ...
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...
How to Print Excel Sheet on One Page Working with Gridlines in Excel How to Set the Print Area in Excel Worksheets How to Insert a Picture in Excel Comment How to Print Multiple Sheets in Excel How to Print the Top Row on Every Page in Excel...
How to Fit a Spreadsheet on One Page in Excel How to Print the Top Row On Every Page in Excel 2013 How to Print Double-Sided on Google Docs: A Step-by-Step Guide How to Print from Google Docs on iPhone or Android How to Print from Microsoft Word for Office 365: A Step-by-Step ...
click inside the "Rows to repeat at top" box and highlight your header row cells Step 3:Before printing, use the print preview feature to verify your header rows will repeat adequately. Check that the selected titles appear on each preview page. ...
PrintOut from:=xPages, To:=xPages End With End If End Sub Copy 3. Press the F5 key to run the code, then a Kutool for Excel dialog box pops up, please select the row range you need to repeat on top of every printout except the last page, and then click the OK button. See ...
PressCtrl+Pto open the print preview. The lines of data have moved and there are now lines that were not previously on the last printed page. To adjust the data,find the rowthat should be thefirst lineof the next printed page.