{"id":458,"date":"2019-01-03T00:40:43","date_gmt":"2019-01-03T00:40:43","guid":{"rendered":"http:\/\/www.alandaletraining.com\/software-tips\/?p=458"},"modified":"2019-01-03T00:40:47","modified_gmt":"2019-01-03T00:40:47","slug":"how-to-lock-column-row-headings-in-place-in-excel","status":"publish","type":"post","link":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/","title":{"rendered":"How to lock column & row headings in place in Excel"},"content":{"rendered":"

In a large Excel worksheet with many rows and columns, when you scroll down or across the column and row headings disappear and it can be difficult knowing what the data you are looking at applies to.\u00a0 The Freeze Panes command lets you lock row and column headings in place so they stay visible as you scroll.<\/p>\n

To lock rows and columns in place, you’d expect to select the rows or columns you want to freeze and then use the command.\u00a0 In fact, somewhat counter-intuitively, when you Freeze Panes the rows above<\/u> and columns to the left<\/u> of the active cell are locked in place.<\/p>\n

To lock headings in place:<\/p>\n

    \n
  1. Click on the cell below and to the right of the rows and columns you want to lock in place<\/li>\n
  2. On the View tab, in the Window group, click on the Freeze Panes button<\/li>\n
  3. Select Freeze Panes
    \n\"\"<\/li>\n<\/ol>\n

    The Freeze Panes command changes to Unfreeze Panes when after you apply Freeze Panes.<\/p>\n

    If things don’t work out as you expect, remove the panes by using the Unfreeze Panes command: click on the Freeze Panes button then select Unfreeze Panes.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In a large Excel worksheet with many rows and columns, when you scroll down or across the column and row headings disappear and it can be difficult knowing what the …<\/p>\n","protected":false},"author":4,"featured_media":459,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\nHow to lock column & row headings in place in Excel - Alandale Training Software Tips<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to lock column & row headings in place in Excel - Alandale Training Software Tips\" \/>\n<meta property=\"og:description\" content=\"In a large Excel worksheet with many rows and columns, when you scroll down or across the column and row headings disappear and it can be difficult knowing what the ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Alandale Training Software Tips\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-03T00:40:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-03T00:40:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2019\/01\/Freeze-Panes.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"497\" \/>\n\t<meta property=\"og:image:height\" content=\"259\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"John Chandler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Chandler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to lock column & row headings in place in Excel - Alandale Training Software Tips","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:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to lock column & row headings in place in Excel - Alandale Training Software Tips","og_description":"In a large Excel worksheet with many rows and columns, when you scroll down or across the column and row headings disappear and it can be difficult knowing what the ...","og_url":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/","og_site_name":"Alandale Training Software Tips","article_published_time":"2019-01-03T00:40:43+00:00","article_modified_time":"2019-01-03T00:40:47+00:00","og_image":[{"width":497,"height":259,"url":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2019\/01\/Freeze-Panes.jpg","type":"image\/jpeg"}],"author":"John Chandler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Chandler","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/"},"author":{"name":"John Chandler","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4"},"headline":"How to lock column & row headings in place in Excel","datePublished":"2019-01-03T00:40:43+00:00","dateModified":"2019-01-03T00:40:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/"},"wordCount":198,"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2019\/01\/Freeze-Panes.jpg","articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/","url":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/","name":"How to lock column & row headings in place in Excel - Alandale Training Software Tips","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2019\/01\/Freeze-Panes.jpg","datePublished":"2019-01-03T00:40:43+00:00","dateModified":"2019-01-03T00:40:47+00:00","author":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2019\/01\/03\/how-to-lock-column-row-headings-in-place-in-excel\/#primaryimage","url":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2019\/01\/Freeze-Panes.jpg","contentUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2019\/01\/Freeze-Panes.jpg","width":497,"height":259},{"@type":"WebSite","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website","url":"https:\/\/www.alandaletraining.com\/software-tips\/","name":"Alandale Training Software Tips","description":"Weekly Software Tips","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.alandaletraining.com\/software-tips\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4","name":"John Chandler","sameAs":["http:\/\/AlandaleTraining.com"],"url":"https:\/\/www.alandaletraining.com\/software-tips\/author\/john1973\/"}]}},"_links":{"self":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/comments?post=458"}],"version-history":[{"count":1,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/458\/revisions"}],"predecessor-version":[{"id":460,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/458\/revisions\/460"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media\/459"}],"wp:attachment":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media?parent=458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/categories?post=458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/tags?post=458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}