{"id":24684,"date":"2021-07-11T14:38:24","date_gmt":"2021-07-11T12:38:24","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24684"},"modified":"2024-05-09T20:33:12","modified_gmt":"2024-05-09T18:33:12","slug":"print-excel-header-row-and-column-on-every-page","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/print-excel-header-row-and-column-on-every-page\/","title":{"rendered":"Print Excel header row and column on Every Page"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/31.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24781\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/31.png\" alt=\"Print Excel header row and column on Every Page\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/31.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/31-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/31-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>If you have a <strong>large data file with headers on the top<\/strong>, you can <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-freeze-panes-in-excel\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>freeze<\/strong><\/a> the columns to easily view the entire table without losing sight of the headers.<\/p>\n<p>But the<strong> freeze feature will not be applied when you try to print<\/strong> the file.<\/p>\n<p>To print<strong> Excel header row\u00a0on every page<\/strong>, you can try one of the following methods as per your requirement:<\/p>\n<ul>\n<li><a href=\"#lesson1\"><strong>Repeat row on every page<\/strong><\/a><\/li>\n<li><a href=\"#lesson2\"><strong>Repeat column on every page<\/strong><\/a><\/li>\n<li><a href=\"#lesson3\"><strong>Print row numbers and column letters<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s try to understand each of these methods one by one!<\/p>\n<p>Don&#8217;t forget to download this Excel Workbook on how to print Excel header row on every page to follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print-Row-and-Column-Headers.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Print-Row-and-Column-Headers.xlsx<\/span><\/a> <i class=\"fa fa-download\"><\/i><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><strong><a id=\"lesson1\"><\/a>Repeat row on every page<\/strong><\/span><\/h3>\n<p>If you have a large worksheet that spans over multiple pages, you can easily <strong>print the first row of the data as headers in Excel on every page<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24696\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print6.png\" alt=\"Print Excel header row and column on Every Page\" width=\"1072\" height=\"479\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print6.png 1072w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print6-300x134.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print6-1024x458.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print6-768x343.png 768w\" sizes=\"(max-width: 1072px) 100vw, 1072px\" \/><\/a><\/p>\n<p>Follow the steps below to print a row of every page:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong> <\/span>Go to Page Layout tab &gt; Select Print Tiles<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24691\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png\" alt=\"Print Excel header row and column on Every Page\" width=\"1023\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png 1023w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1-768x96.png 768w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong> <\/span>In the Page Setup dialog box, select <strong>Sheet<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24692\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png\" alt=\"Print Excel header row and column on Every Page\" width=\"534\" height=\"451\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2-300x253.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong> <\/span>Select the collapse dialog box and pick the row you wish to repeat.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24693\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print3.png\" alt=\"Print Excel header row and column on Every Page\" width=\"863\" height=\"567\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print3.png 863w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print3-300x197.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print3-768x505.png 768w\" sizes=\"(max-width: 863px) 100vw, 863px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong> <\/span>Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24694\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print4.png\" alt=\"Print Excel header row and column on Every Page\" width=\"537\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print4.png 537w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print4-300x253.png 300w\" sizes=\"(max-width: 537px) 100vw, 537px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 5:<\/strong> <\/span>Press Ctrl + P to open Print Preview.<\/p>\n<p>As you can see we are on page 5 but the 1st row is still visible!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone wp-image-24695 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print5.png\" alt=\"Print Excel header row and column on Every Page\" width=\"1085\" height=\"691\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print5.png 1085w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print5-300x191.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print5-1024x652.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print5-768x489.png 768w\" sizes=\"(max-width: 1085px) 100vw, 1085px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #008000\"><strong><a id=\"lesson2\"><\/a>Repeat column on every page<\/strong><\/span><\/h3>\n<p>When your Excel worksheet has multiple columns and is spread across several pages, you can fix the first column.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24698\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print7.png\" alt=\"Print Excel header row and column on Every Page\" width=\"451\" height=\"585\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print7.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print7-231x300.png 231w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>Follow the<strong> steps below<\/strong> to fix the first column when printing:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong> <\/span>Go to<strong> Page Layout<\/strong> &gt; Select <strong>Print Tiles<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24691\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png\" alt=\"Print Excel header row and column on Every Page\" width=\"1023\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png 1023w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1-768x96.png 768w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong> <\/span>In the Page Setup dialog box, select <strong>Sheet<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24692\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png\" alt=\"Print Excel header row and column on Every Page\" width=\"534\" height=\"451\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2-300x253.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong> <\/span>Select the <strong>collapse dialog box<\/strong> and pick the column you wish to repeat.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24699\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print9.png\" alt=\"Print Excel header row and column on Every Page\" width=\"536\" height=\"454\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print9.png 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print9-300x254.png 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong> <\/span>Click OK<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24700\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print10.png\" alt=\"Print Excel header row and column on Every Page\" width=\"536\" height=\"454\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print10.png 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print10-300x254.png 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p>And it&#8217;s done! Column A is still visible when you go to page 2.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24701\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print11.png\" alt=\"Print Excel header row and column on Every Page\" width=\"1155\" height=\"699\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print11.png 1155w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print11-300x182.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print11-1024x620.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print11-768x465.png 768w\" sizes=\"(max-width: 1155px) 100vw, 1155px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><strong><a id=\"lesson3\"><\/a>Print row numbers and column letters<\/strong><\/span><\/h3>\n<p>Excel denotes the worksheet&#8217;s columns as letters (A, B, C, etc) and rows as numbers (1, 2, 3, etc). But when you try to print your worksheet, it is not visible at all.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24702\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print12.png\" alt=\"Print Excel header row and column on Every Page\" width=\"967\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print12.png 967w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print12-300x141.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print12-768x360.png 768w\" sizes=\"(max-width: 967px) 100vw, 967px\" \/><\/a><\/p>\n<p>You can easily print numbers and column letters by following the steps below:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong> <\/span>Go to<strong> Page Layout<\/strong> &gt; Select <strong>Print Tiles<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24691\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png\" alt=\"Print Excel header row and column on Every Page\" width=\"1023\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1.png 1023w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print1-768x96.png 768w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong> <\/span>In the Page Setup dialog box, select <strong>Sheet<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24692\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png\" alt=\"Print Excel header row and column on Every Page\" width=\"534\" height=\"451\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print2-300x253.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong> <\/span>Check <strong>Row and column headings<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24708\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print13.png\" alt=\"Print Excel header row and column on Every Page\" width=\"536\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print13.png 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print13-300x254.png 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong> <\/span>Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24709\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print15.png\" alt=\"Print Excel header row and column on Every Page\" width=\"535\" height=\"456\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print15.png 535w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print15-300x256.png 300w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 5:<\/strong> <\/span>Press<strong> Ctrl + P<\/strong> to view Print Preview.<\/p>\n<p>The row numbers and column letters will be displayed in the print preview section!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel header row and column on Every Page\" class=\"alignnone size-full wp-image-24710\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print14.png\" alt=\"Print Excel header row and column on Every Page\" width=\"1115\" height=\"697\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print14.png 1115w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print14-300x188.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print14-1024x640.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print14-768x480.png 768w\" sizes=\"(max-width: 1115px) 100vw, 1115px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\">Conclusion<\/span><\/h3>\n<p>Now you can easily <strong>add Excel header row, Excel column headers, and row-column headings<\/strong> on every page when you print your worksheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/macros\/printing-macros\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to learn what customization you can do before you print your document!<\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have a large data file with headers on the top, you can freeze the columns to easily view the entire table without losing sight of the headers. But the freeze feature will not be applied when you try to print the file. To print Excel header row\u00a0on every page, you can try one [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24781,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Print Excel header row and column on Every Page","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[10,648],"tags":[767,766],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24684"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=24684"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24684\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/24781"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}