{"id":1091,"date":"2022-11-30T15:59:12","date_gmt":"2022-11-30T15:59:12","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1091"},"modified":"2024-02-20T20:31:26","modified_gmt":"2024-02-20T20:31:26","slug":"how-to-print-top-row-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-print-top-row-in-excel\/","title":{"rendered":"How to Print Top Row on Every page in Excel?"},"content":{"rendered":"

Print Top Row on Every Page in Excel ensures consistent header visibility, data organization, and professional presentation. By retaining the top row across all printed pages, users can easily reference column labels, navigate datasets, and maintain document structure. This feature enhances readability, productivity, and the overall appearance of printed Excel documents, making it a valuable tool for effective data management and presentation.<\/p>\n

This Tutorial Covers:<\/strong><\/p>\n

How to print top row\/rows in every page of Excel?<\/strong><\/h2>\n
    \n
  1. Print top row or header in the all the pages<\/a><\/li>\n
  2. Print first two rows or header in the all the pages<\/a><\/li>\n<\/ol>\n

    How to print row and column headers of Excel spreadsheets on every page?<\/strong><\/h2>\n

    By\u00a0following these steps, you can set it to repeat multiple top rows or left columns on each page.<\/p>\n

    This is a large data set of 90 rows, if you print without any top row set up then only in first page the top row or header will appear. Other pages will not have the top header.<\/p>\n

    \"Print<\/p>\n

    1. Print top row or header in the all the pages<\/strong><\/h3>\n

    We want to bring top row or header in the all the pages. See the following steps.<\/p>\n

    Step 1: <\/strong>Go to PAGE LAYOUT. In the Page Setup area of the ribbon, click on the dialog box launcher, which is represented by the small tilted arrow in the image below.<\/p>\n

    \"Print<\/p>\n

    Step 2: <\/strong>Ensure you’re on the Sheet tab of the Page Setup dialog box.<\/p>\n

    Step 3: <\/strong>In the \u2018Rows to Repeat at top\u2019 section, click on the up indicator.<\/p>\n

    \"Print<\/p>\n

    Step 4: <\/strong>Then select the row 1 of your excel sheet. Or you can directly write $1: $1 in the box to repeat the row in each page while printing.<\/p>\n

    \"Print<\/p>\n

    Step 5: <\/strong>Choose a row or several rows to print on each page. Click OK.<\/p>\n

    \"Print<\/p>\n

    Now see the print preview:<\/p>\n

    \"Print<\/p>\n

    Now you have top row or row header in the all the pages.<\/p>\n

    \"Print<\/p>\n

    2. Print first two rows or header in the all the pages<\/strong><\/h3>\n

    If you want to show multiple rows, say first two rows of below data table. Follow below steps:<\/p>\n

    \"Print<\/p>\n

    Step 1: <\/strong>Go to PAGE LAYOUT. In the Page Setup area of the ribbon, click on the dialog box launcher, which is represented by the small tilted arrow in the image below.<\/p>\n

    Step 2: <\/strong>Ensure you’re on the Sheet tab of the Page Setup dialog box.<\/p>\n

    Step 3: <\/strong>In the \u2018Rows to repeat at top\u2019 section you should select rows $1:$2 to show top two rows in the each page.<\/p>\n

    \"Print<\/p>\n

    Step 4: <\/strong>Click OK.<\/p>\n

    Application of\u00a0<\/strong>Print Top Row on Every Page in Excel<\/h2>\n