You can go for a Print Preview, Print the contents or save the settings by hitting on Ok. Step 5: Back on the Page Setup modal window, you will see the text boxes populated with the row/column values to repeat on each page. Generally, you would want the top row and at rare circumstances the leftmost column. Here, you can select multiple rows if you wish you repeat them on each page. Click on row number 1 (on the sheet) and hit the dialog box right end button again. Step 4: That will take you to the Excel sheet along with a dialog box. Step 3: To setup printing of top row on each page click on the button placed against Rows to repeat at top text box. Though we are focusing on header row, you must have understood that the setting can be applied to columns as well. Step 2: On the Page Setup modal window, switch to the tab for Sheet and spot the section for Print titles. Then click on the icon for Page Titles placed under Page Setup section. Step 1: On your workbook, select the desired sheet and navigate to Page Layout tab on the ribbon.
I am not very sure about earlier ones but you may want to check it out. This setup applies to Office 2007 and later versions. Setup Printing of Top Row on Every Excel Page Whereas with data on multiple pages you would want the first row or column to appear at the top row of each page, right? We will learn how to make that happen, today.Ĭool Tip: In case you are looking to print your company name, address, logo and akin on every page then I suggest that you add a page header and configure the settings as described in our detailed guide. But, when you wish to print the document or convert it to PDF, for example, the header row prints only once. With soft copies that works absolutely fine. That way the header row would always be visible irrespective of how deep you scroll.
0 kommentar(er)
