{"id":9016,"date":"2022-02-15T18:09:55","date_gmt":"2022-02-15T18:09:55","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9016"},"modified":"2024-03-26T15:33:08","modified_gmt":"2024-03-26T15:33:08","slug":"freeze-or-fix-column-or-row-headings","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/","title":{"rendered":"Freeze or Fix Column or Row Headings in Excel"},"content":{"rendered":"\n
Freeze-or-Fix-Column-or-Row-Headings-in-Excel<\/a>Download File<\/a><\/div>\n\n\n\n

When you have to work with a large Excel spreadsheet, you can easily lose track of exactly what kind of information is included in certain columns or rows when scrolling around the sheet.<\/p>\n\n\n\n

When you are at the very top of the spreadsheet, all headers are visible, but when you start scrolling the window they stay on the top of the spreadsheet, disappearing from the view.<\/p>\n\n\n\n

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

There are a few ways to fix it.<\/p>\n\n\n\n

Freeze the top row with a table<\/h2>\n\n\n\n

When you create a table (Insert >> Tables >> Table<\/strong>), and start scrolling, the header turns grey, but it stays on the top, instead of disappearing.<\/p>\n\n\n\n

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

Freeze the top row<\/h2>\n\n\n\n

If you don\u2019t want to create a table from the data, or just want to keep the header with the same formatting as before, you can go to View >> Window >> Freeze Panes<\/strong> and click Freeze Top Row<\/strong>.<\/p>\n\n\n\n

This action will lock the first row of the spreadsheet across all columns from A<\/strong> to XFD<\/strong>.<\/p>\n\n\n\n

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

Freeze the first column<\/h2>\n\n\n\n

Similarly, you can freeze the first column. Go to View >> Window >> Freeze Panes<\/strong>, but instead of choosing Freeze Top Row<\/strong>, choose Freeze First Column<\/strong>.<\/p>\n\n\n\n

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

Freeze several columns and rows<\/h2>\n\n\n\n

So far so good, but let\u2019s say that the cells in the first two rows are merged. When you use the Freeze Top Row<\/strong> method, there are going to be problems.<\/p>\n\n\n\n

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

The cells First Name<\/strong> and Last Name<\/strong> occupy two rows and Age<\/strong> and (years)<\/strong> are inside single cells. When you try to lock the top row, you will get strange results:<\/p>\n\n\n\n

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

We can easily fix this problem by using another option, called Freeze Panes<\/strong>, located under the same button.<\/p>\n\n\n\n

Before you do that, click cell A3<\/strong> and choose the option. If you try to freeze panes while your active cell isn\u2019t in column A<\/strong>, all columns on the left will also be frozen. This way you can lock both horizontal and vertical headings simultaneously.<\/p>\n\n\n\n

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

Unfreeze panes<\/h2>\n\n\n\n

If you want to get rid of the frozen panes, you can click the Unfreeze Panes<\/strong> button and all the rows and columns will be restored.<\/p>\n\n\n\n

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

When you have to work with a large Excel spreadsheet, you can easily lose track of exactly what kind of information is included…<\/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":"\nFreeze or Fix Column or Row Headings in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to freeze or fix column or row headings in Excel to keep track of information while scrolling through large spreadsheets. Download the guide 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\/freeze-or-fix-column-or-row-headings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Freeze or Fix Column or Row Headings in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to freeze or fix column or row headings in Excel to keep track of information while scrolling through large spreadsheets. Download the guide now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-15T18:09:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T15:33:08+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Freeze or Fix Column or Row Headings in Excel\",\"datePublished\":\"2022-02-15T18:09:55+00:00\",\"dateModified\":\"2024-03-26T15:33:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/\"},\"wordCount\":376,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/\",\"name\":\"Freeze or Fix Column or Row Headings in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png\",\"datePublished\":\"2022-02-15T18:09:55+00:00\",\"dateModified\":\"2024-03-26T15:33:08+00:00\",\"description\":\"Learn how to freeze or fix column or row headings in Excel to keep track of information while scrolling through large spreadsheets. Download the guide now.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Freeze or Fix Column or Row Headings in Excel\"}]},{\"@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":"Freeze or Fix Column or Row Headings in Excel","description":"Learn how to freeze or fix column or row headings in Excel to keep track of information while scrolling through large spreadsheets. Download the guide 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\/freeze-or-fix-column-or-row-headings\/","og_locale":"en_US","og_type":"article","og_title":"Freeze or Fix Column or Row Headings in Excel","og_description":"Learn how to freeze or fix column or row headings in Excel to keep track of information while scrolling through large spreadsheets. Download the guide now.","og_url":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/","article_published_time":"2022-02-15T18:09:55+00:00","article_modified_time":"2024-03-26T15:33:08+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Freeze or Fix Column or Row Headings in Excel","datePublished":"2022-02-15T18:09:55+00:00","dateModified":"2024-03-26T15:33:08+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/"},"wordCount":376,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/","url":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/","name":"Freeze or Fix Column or Row Headings in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png","datePublished":"2022-02-15T18:09:55+00:00","dateModified":"2024-03-26T15:33:08+00:00","description":"Learn how to freeze or fix column or row headings in Excel to keep track of information while scrolling through large spreadsheets. Download the guide now.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-12.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/freeze-or-fix-column-or-row-headings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Freeze or Fix Column or Row Headings in Excel"}]},{"@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\/9016"}],"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=9016"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9016\/revisions"}],"predecessor-version":[{"id":14039,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9016\/revisions\/14039"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}