{"id":622,"date":"2023-02-10T15:55:31","date_gmt":"2023-02-10T20:55:31","guid":{"rendered":"http:\/\/www.kevinconvery.com\/?page_id=622"},"modified":"2023-02-11T14:58:37","modified_gmt":"2023-02-11T19:58:37","slug":"how-to-freeze-cells-in-excel","status":"publish","type":"page","link":"http:\/\/www.kevinconvery.com\/?page_id=622","title":{"rendered":"How to Freeze Cells in Excel"},"content":{"rendered":"\n<p><em>Forgetting what column or row you&#8217;re looking at? We can help.<\/em><\/p>\n\n\n\n<p>by Kevin Convery<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-34.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1000\" src=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-34-1024x1000.png\" alt=\"\" class=\"wp-image-690\" srcset=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-34-1024x1000.png 1024w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-34-300x293.png 300w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-34-768x750.png 768w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-34-1536x1500.png 1536w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-34-2048x2000.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>If you have ever used Excel to review a large database, you know how useful it is to be able to freeze cells, such as the top row or the first column. It\u2019s so handy because these two places are where your headings are. Freezing the top row or first column lets you keep your headings visible as you scroll through rows and columns of data. It\u2019s easy to do, but with Excel\u2019s rich feature set, the control for it might be a little hard to find. We\u2019ll lead you right to it.<\/p>\n\n\n\n<p><strong>QUICK ANSWER<\/strong><\/p>\n\n\n\n<p>With Excel open, go to View &gt; Freeze Panes. Choose Freeze Top Row to keep row 1 visible no matter how far down you scroll.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>How to freeze the top row in Excel<\/p>\n\n\n\n<p>With Excel open, click on the View menu at the top of the page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-9-1024x576.png\" alt=\"\" class=\"wp-image-624\" srcset=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-9-1024x576.png 1024w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-9-300x169.png 300w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-9-768x432.png 768w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-9.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In the View menu, click on the Freeze Panes button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-10.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-10-1024x576.png\" alt=\"\" class=\"wp-image-625\" srcset=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-10-1024x576.png 1024w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-10-300x169.png 300w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-10-768x432.png 768w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-10.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>From the menu that drops down, select Freeze Top Row.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-11.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-11-1024x576.png\" alt=\"\" class=\"wp-image-626\" srcset=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-11-1024x576.png 1024w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-11-300x169.png 300w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-11-768x432.png 768w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-11.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>As you can see, when we scroll down through the worksheet, Row 1 is still visible.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-12.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-12-1024x576.png\" alt=\"\" class=\"wp-image-627\" srcset=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-12-1024x576.png 1024w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-12-300x169.png 300w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-12-768x432.png 768w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-12.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>How to freeze the first column in an Excel worksheet<\/strong><\/p>\n\n\n\n<p>Follow the instructions above but, when you click on the Freeze Panes button, select Freeze First Column.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-13.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-13-1024x576.png\" alt=\"\" class=\"wp-image-628\" srcset=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-13-1024x576.png 1024w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-13-300x169.png 300w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-13-768x432.png 768w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-13.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The first column will now stay in view as we scroll to the right.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>How to freeze rows and columns at the same time<\/strong><\/p>\n\n\n\n<p>If you have headers both along the top and down the left side of your worksheet, it makes sense to freeze them both. You can do this by choosing the third choice inside the Freeze Panes button, Freeze Panes.<\/p>\n\n\n\n<p>This is a very flexible command, which will let you freeze as many panes (cells), vertically or horizontally, as you want. How many will be frozen depends on which cells you have selected at the time you freeze the panes. Specifically, to freeze just the top row and the leftmost column, select cell B2.<\/p>\n\n\n\n<p>Now activate the Freeze Panes command. Excel will freeze every column to the left of B2 and every row above B2. In other words, Row 1 and Column A are now frozen. You can now scroll through any size worksheet, horizontally or vertically, without losing sight of your headings.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-14-1024x576.png\" alt=\"\" class=\"wp-image-629\" srcset=\"http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-14-1024x576.png 1024w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-14-300x169.png 300w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-14-768x432.png 768w, http:\/\/www.kevinconvery.com\/wp-content\/uploads\/2023\/02\/image-14.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>FAQs<\/strong><\/p>\n\n\n\n<p><strong>Why is the text in my cell replaced with ########?<\/strong><\/p>\n\n\n\n<p>The cell is not wide enough to display the whole text. Grab the right border of the cell and move it rightward to make the column wider.<\/p>\n\n\n\n<p><strong>Is there a free version of Excel?<\/strong><\/p>\n\n\n\n<p>Yes, there are free online versions of all the Office apps available at www.office.com.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Forgetting what column or row you&#8217;re looking at? We can help. by Kevin Convery If you have ever used Excel to review a large database, you know how useful it is to be able to freeze cells, such as the top row or the first column. It\u2019s so handy because these two places are where [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":688,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=\/wp\/v2\/pages\/622"}],"collection":[{"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=622"}],"version-history":[{"count":3,"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=\/wp\/v2\/pages\/622\/revisions"}],"predecessor-version":[{"id":692,"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=\/wp\/v2\/pages\/622\/revisions\/692"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=\/wp\/v2\/media\/688"}],"wp:attachment":[{"href":"http:\/\/www.kevinconvery.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}