![]() The print preview will show you exactly what will be printed on each sheet. Note: It’s best to check the print preview before printing the worksheet. You can use the same steps to also repeat multiple rows on each page (in case your headers occupy more than one row), as well as repeat one or more than one column on each page. Now, when you print the data, you will have the selected header row cells repeat on every page. In the dataset, select the header cells (you can also select the entire row if you want).In the Page Setup dialog box, click on the cell selector icon (upward arrow) for the ‘Rows to repeat at top’ option.This will open the ‘Page Setup’ dialog box ![]() In the Page Setup group, click on the ‘Print Titles’ option.Click on the Page Layout option in the ribbon.If you print this data in the current form, you will only get the header on the first page and rest all the page will have only the data and not the headers.īelow are the steps to make sure the headers repeat on every printed page: Suppose you have a dataset as shown below where there are hundreds of rows of data with the header in the first row. How to Set a Row to Print on Every Page in Excel In this tutorial, I will show you all the steps you need to do set the headers to show up on every printed page. ![]() Thankfully, there is an in-built feature in Excel that allows you to set a row to print on every page (or set a column to print on every page). This is often needed as you want the data row headers to be visible so that it’s easier to know what a data point represents. If you often print your work in Excel, you would benefit from knowing how to make sure a row (or multiple rows) print on every page that you print.
0 Comments
Leave a Reply. |