{"id":6853,"date":"2019-07-06T10:07:42","date_gmt":"2019-07-06T10:07:42","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=6853"},"modified":"2023-11-11T16:28:16","modified_gmt":"2023-11-11T16:28:16","slug":"freeze-columns-excel","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/freeze-columns-excel\/","title":{"rendered":"Freezing Columns in Excel"},"content":{"rendered":"
\n

In Excel, freezing the first column (the leftmost) is pretty easy.<\/p>\n

Similarly, freezing two or more columns is easy but a little trick is required.<\/p>\n

Keep reading the tutorial below to learn how to freeze one or more columns in Excel.<\/p>\n<\/div>\n

\"Animated<\/p>\n

Freezing the first column example<\/strong><\/h3>\n

In certain scenarios, the first column may contain sheet headers that you may want to always keep in view as navigating or working in the worksheet.<\/p>\n

Excel allows you to freeze the first column and top row easily.<\/p>\n

For freezing the first column and top row, the options in the menu are available straight away. Follow the steps below for doing that:<\/p>\n

Step 1<\/div>\n

Go to \u201cView<\/strong>\u201d in the ribbon.<\/p>\n

Step 2<\/div>\n

Find the \u201cFreeze Panes<\/strong>\u201d group.<\/p>\n

Step 3<\/div>\n

Open the menu with a small arrow and select \u201cFreeze First Column<\/strong>\u201d<\/p>\n

\"Excel<\/p>\n

This will freeze the first column. As you navigate towards the right, this column should always be in view for that worksheet (as shown in the above graphic).<\/p>\n

Similarly, you may freeze the top row<\/strong> by clicking the Freeze Top Row<\/strong> under the \u201cFreeze Panes<\/strong>\u201d menu.<\/p>\n

Note:<\/strong> If you freeze the first column, it remains visible for horizontal movement only. If you navigate downwards\/vertically, the column values move.<\/div>\n

How to freeze multiple columns?<\/strong><\/h3>\n

Suppose, you want to freeze columns A and B. So, their content is in focus as you move horizontally to the other columns.<\/p>\n

Follow these steps:<\/p>\n

Step 1<\/div>\n

Select the column C<\/strong> or C1<\/strong> cell<\/p>\n

Step 2<\/div>\n

Go to View in the ribbon.<\/p>\n

Step 3<\/div>\n

Look for the \u201cFreeze Panes<\/strong>\u201d group<\/p>\n

Step 4<\/div>\n

Click the small arrow and press the \u201cFreeze Panes<\/strong>\u201d in the menu as shown in the graphic below<\/p>\n

\"Excel<\/p>\n

Now, as you move towards the right horizontally, columns A and B should stay in place while other columns should move.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.<\/p>\n","protected":false},"author":1,"featured_media":6855,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[143,71],"tags":[],"yoast_head":"\n2 Examples of How to freeze First and multiple columns in Excel<\/title>\n<meta name=\"description\" content=\"In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/freeze-columns-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2 Examples of How to freeze First and multiple columns in Excel\" \/>\n<meta property=\"og:description\" content=\"In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/freeze-columns-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-06T10:07:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-11T16:28:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2019\/06\/48.1-Excel-freeze-column.png\" \/>\n\t<meta property=\"og:image:width\" content=\"712\" \/>\n\t<meta property=\"og:image:height\" content=\"281\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/freeze-columns-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2019\/06\/48.1-Excel-freeze-column.png\",\"width\":712,\"height\":281,\"caption\":\"Excel freeze column\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/freeze-columns-excel\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/freeze-columns-excel\/\",\"name\":\"2 Examples of How to freeze First and multiple columns in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/freeze-columns-excel\/#primaryimage\"},\"datePublished\":\"2019-07-06T10:07:42+00:00\",\"dateModified\":\"2023-11-11T16:28:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"description\":\"In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/freeze-columns-excel\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/6853"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=6853"}],"version-history":[{"count":4,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/6853\/revisions"}],"predecessor-version":[{"id":9807,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/6853\/revisions\/9807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/6855"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=6853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=6853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=6853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}