{"id":9031,"date":"2022-02-16T16:24:59","date_gmt":"2022-02-16T16:24:59","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9031"},"modified":"2024-03-28T13:40:06","modified_gmt":"2024-03-28T13:40:06","slug":"repeat-excel-spreadsheet-column-headings-at-top-of-page","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/","title":{"rendered":"Repeat Excel Spreadsheet Column Headings at Top of Page"},"content":{"rendered":"\n
Repeat-Excel-Spreadsheet-Column-Headings-at-Top-of-Page<\/a>Download File<\/a><\/div>\n\n\n\n

If you have a long list of data that spans multiple pages, you can print column headers with the first part of the records on the first page and the rest of the records on other pages.<\/p>\n\n\n\n

When you look at the first page, the column headers are at the top.<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

This is the second page.<\/p>\n\n\n\n

\"A<\/figure>\n\n\n\n

Because headers are printed only on the first page, keeping track of which data belongs to which header can be hard, especially when you deal with many columns.<\/p>\n\n\n\n

Repeat the row with column headers<\/h2>\n\n\n\n

If you want to print rows at the top of every printed page, please follow the steps below:<\/p>\n\n\n\n

    \n
  1. Navigate to Page Layout >> Page Setup<\/strong> and click Print Titles<\/strong>.<\/li>\n<\/ol>\n\n\n\n
    \"Application\n\nDescription<\/figure>\n\n\n\n
      \n
    1. Click the Sheet<\/strong> tab.<\/li>\n\n\n\n
    2. Click inside Rows to repeat at top:<\/strong> text field.<\/li>\n\n\n\n
    3. Move your cursor outside the window and click the first row.<\/li>\n<\/ol>\n\n\n\n
      \"Graphical<\/figure>\n\n\n\n
        \n
      1. Click OK<\/strong> or Print Preview<\/strong>.<\/li>\n<\/ol>\n\n\n\n

        The column headers are added to the second and remaining pages.<\/p>\n\n\n\n

        \"Table\n\nDescription<\/figure>\n\n\n\n

        Repeat columns<\/h2>\n\n\n\n

        Similarly, you can repeat columns. Let\u2019s transpose the data to see what it looks like.<\/p>\n\n\n\n

        Page 1:<\/strong><\/p>\n\n\n\n

        \"Text\n\nDescription<\/figure>\n\n\n\n

        Page 2:<\/strong><\/p>\n\n\n\n

        \"Text\n\nDescription<\/figure>\n\n\n\n

        Select Page Layout >> Page Setup >> Print Titles<\/strong> and click inside Columns to repeat at left:<\/strong> textbox.<\/p>\n\n\n\n

        Click a cell inside the first column and press OK<\/strong>.<\/p>\n\n\n\n

        \"A<\/figure>\n\n\n\n

        Now, if you try to print the sheet<\/a>, the first column with headers is also copied to the next pages.<\/p>\n\n\n\n

        \"Text\n\nDescription<\/figure>\n","protected":false},"excerpt":{"rendered":"

        If you have a long list of data that spans multiple pages, you can print column headers with the first part of the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nRepeat Excel Spreadsheet Column Headings at Top of Page<\/title>\n<meta name=\"description\" content=\"Learn how to print column headers on multiple pages in #Excel easily. Follow these simple steps to keep track of your data. Download the sample file now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Repeat Excel Spreadsheet Column Headings at Top of Page\" \/>\n<meta property=\"og:description\" content=\"Learn how to print column headers on multiple pages in #Excel easily. Follow these simple steps to keep track of your data. Download the sample file now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-16T16:24:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:40:06+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Repeat Excel Spreadsheet Column Headings at Top of Page\",\"datePublished\":\"2022-02-16T16:24:59+00:00\",\"dateModified\":\"2024-03-28T13:40:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/\"},\"wordCount\":242,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/\",\"name\":\"Repeat Excel Spreadsheet Column Headings at Top of Page\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png\",\"datePublished\":\"2022-02-16T16:24:59+00:00\",\"dateModified\":\"2024-03-28T13:40:06+00:00\",\"description\":\"Learn how to print column headers on multiple pages in #Excel easily. Follow these simple steps to keep track of your data. Download the sample file now!\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Repeat Excel Spreadsheet Column Headings at Top of Page\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Repeat Excel Spreadsheet Column Headings at Top of Page","description":"Learn how to print column headers on multiple pages in #Excel easily. Follow these simple steps to keep track of your data. Download the sample file now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/","og_locale":"en_US","og_type":"article","og_title":"Repeat Excel Spreadsheet Column Headings at Top of Page","og_description":"Learn how to print column headers on multiple pages in #Excel easily. Follow these simple steps to keep track of your data. Download the sample file now!","og_url":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/","article_published_time":"2022-02-16T16:24:59+00:00","article_modified_time":"2024-03-28T13:40:06+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Repeat Excel Spreadsheet Column Headings at Top of Page","datePublished":"2022-02-16T16:24:59+00:00","dateModified":"2024-03-28T13:40:06+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/"},"wordCount":242,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/","url":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/","name":"Repeat Excel Spreadsheet Column Headings at Top of Page","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png","datePublished":"2022-02-16T16:24:59+00:00","dateModified":"2024-03-28T13:40:06+00:00","description":"Learn how to print column headers on multiple pages in #Excel easily. Follow these simple steps to keep track of your data. Download the sample file now!","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-17.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/repeat-excel-spreadsheet-column-headings-at-top-of-page\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Repeat Excel Spreadsheet Column Headings at Top of Page"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9031"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=9031"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9031\/revisions"}],"predecessor-version":[{"id":14719,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9031\/revisions\/14719"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}