![]() On the Print window, click the Page Setup link to open the Page Setup dialog. Follow the File > Print path in the Ribbon.You can access the Print page using one the following: First, open the Print page and go to the Page Setup window. The other option is a little longer than the Ribbon approach. This menu contains the options to print header row in Excel to repeat on every printed page. Then, click on the Print Titles icon to open the Page Setup dialog. When working on your workbook, begin by going into the Page Layout tab in the Ribbon. Let's see these two methods more in detail. ![]() From the Print window, just before printing.There are 2 ways to open the Page Setup window. You need to activate this feature from the Page Setup options. In this article, we are going to show you how to print header row in Excel to repeat on every printed page in Excel 2016, Excel 2013, Excel 2010 and Excel 2007.īy default, Excel does not print the headings of tables. If your worksheet contains multiple pages, you will see header rows or columns only printed in the first page by default.
0 Comments
Leave a Reply. |