How to Freeze Cells in Excel

  • user warning: Table './tipsformom_drupal/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:05ad70f8da2b2c600648fea0a4229c60' in /var/www/vhosts/tipsformom.com/httpdocs/includes/cache.inc on line 25.
  • user warning: Table './tipsformom_drupal/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<div class=\"mw-parser-output\">\n<p>This wikiHow teaches you how to freeze specific rows and columns in your Microsoft Excel worksheet. Freezing rows or columns ensures that certain cells remain visible as you scroll through the data. If you want to easily edit two parts of the spreadsheet at once, splitting your panes will make the task much easier.\n</p>\n<h2><span class=\"mw-editsection\"><span class=\"mw-editsection-bracket\">[</span><a target=\"_blank\" href=\"https://www.wikihow.com/index.php?title=Freeze-Cells-in-Excel&amp;action=edit&amp;section=1\" title=\"Edit section: Steps\">Edit</a><span class=\"mw-editsection-bracket\">]</span></span><span class=\"mw-headline\" id=\"Steps\">Steps</span></h2>\n<h3><span class=\"mw-editsection\"><span class=\"mw-editsection-bracket\">[</span><a target=\"_blank\" href=\"https://www.wikihow.com/index.php?title=Freeze-Cells-in-Excel&amp;action=edit&amp;section=2\" title=\"Edit section: Freezing the First Column or Row\">Edit</a><span class=\"mw-editsection-bracket\">]</span></span><span class=\"mw-headline\" id=\"Freezing-the-First-Column-or-Row\">Freezing the First Column or Row</span></h3>\n<ol>\n<li>Click the tab. It\'s at the top of Excel. Frozen cells are rows or columns that remain visible while you scroll through a worksheet.<sup id=\"_ref-1\" class=\"reference\" aria-label=\"Link to Reference 1\"><a target=\"_blank\" href=\"#_note-1\">[1]</a></sup> If you want column headers or row labels to remain visible as you work with large amounts of data, you\'ll likely find it helpful to lock those cells into place.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-1-Version-3.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 1 Version 3.jpg\" src=\"https://www.wikihow.com/images/thumb/4/4a/Freeze-Cells-in-Excel-Step-1-Version-3.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-1-Version-3.jpg\" decoding=\"async\" width=\"728\" height=\"546\" class=\"whcdn\" /></a></div>\n<ul>\n<li>Only whole rows or columns can be frozen. It is not possible to freeze individual cells.</li>\n</ul>\n</li>\n<li>Click the button. It\'s in the \"Window\" section of the toolbar. A set of three freezing options will appear.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-2-Version-3.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 2 Version 3.jpg\" src=\"https://www.wikihow.com/images/thumb/e/e8/Freeze-Cells-in-Excel-Step-2-Version-3.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-2-Version-3.jpg\" decoding=\"async\" width=\"728\" height=\"546\" class=\"whcdn\" /></a></div>\n</li>\n<li>Click or . If you want to keep the top row of cells in place as you scroll down through your data, select <b>Freeze Top Row</b>. To keep the first column in place as you scroll horizontally, select <b>Freeze First Column</b>.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-3-Version-3.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 3 Version 3.jpg\" src=\"https://www.wikihow.com/images/thumb/2/29/Freeze-Cells-in-Excel-Step-3-Version-3.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-3-Version-3.jpg\" decoding=\"async\" width=\"728\" height=\"546\" class=\"whcdn\" /></a></div>\n</li>\n<li>Unfreeze your cells. If you want to unlock the frozen cells, click the <b>Freeze Panes</b> menu again and select <b>Unfreeze Panes</b>.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-4-Version-3.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 4 Version 3.jpg\" src=\"https://www.wikihow.com/images/thumb/b/be/Freeze-Cells-in-Excel-Step-4-Version-3.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-4-Version-3.jpg\" decoding=\"async\" width=\"728\" height=\"547\" class=\"whcdn\" /></a></div>\n</li>\n</ol>\n<h3><span class=\"mw-editsection\"><span class=\"mw-editsection-bracket\">[</span><a target=\"_blank\" href=\"https://www.wikihow.com/index.php?title=Freeze-Cells-in-Excel&amp;action=edit&amp;section=3\" title=\"Edit section: Freezing Multiple Columns or Rows\">Edit</a><span class=\"mw-editsection-bracket\">]</span></span><span class=\"mw-headline\" id=\"Freezing-Multiple-Columns-or-Rows\">Freezing Multiple Columns or Rows</span></h3>\n<ol>\n<li>Select the row or column <i>after</i> those you want to freeze. If the data you want to keep stationary takes up more than one row or column, click the column letter or row number <i>after</i> those you want to freeze. For example:<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-5-Version-3.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 5 Version 3.jpg\" src=\"https://www.wikihow.com/images/thumb/2/21/Freeze-Cells-in-Excel-Step-5-Version-3.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-5-Version-3.jpg\" decoding=\"async\" width=\"728\" height=\"545\" class=\"whcdn\" /></a></div>\n<ul>\n<li>If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, click row <b>4</b> to select it.</li>\n<li>If you want columns A and B to remain still as you scroll sideways through your data, click column <b>C</b> to select it.</li>\n<li>Frozen cells must connect to the top or left edge of the spreadsheet. It\'s not possible to freeze rows or columns in the middle of the sheet.<sup id=\"_ref-2\" class=\"reference\" aria-label=\"Link to Reference 2\"><a target=\"_blank\" href=\"#_note-2\">[2]</a></sup></li>\n</ul>\n</li>\n<li>Click the tab. It\'s at the top of Excel.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-6-Version-2.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 6 Version 2.jpg\" src=\"https://www.wikihow.com/images/thumb/a/a2/Freeze-Cells-in-Excel-Step-6-Version-2.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-6-Version-2.jpg\" decoding=\"async\" width=\"728\" height=\"547\" class=\"whcdn\" /></a></div>\n</li>\n<li>Click the button. It\'s in the \"Window\" section of the toolbar. A set of three freezing options will appear.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-7-Version-2.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 7 Version 2.jpg\" src=\"https://www.wikihow.com/images/thumb/7/7c/Freeze-Cells-in-Excel-Step-7-Version-2.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-7-Version-2.jpg\" decoding=\"async\" width=\"728\" height=\"543\" class=\"whcdn\" /></a></div>\n</li>\n<li>Click on the menu. It\'s at the top of the menu. This freezes the columns or rows before the one you selected.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-8-Version-2.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 8 Version 2.jpg\" src=\"https://www.wikihow.com/images/thumb/4/44/Freeze-Cells-in-Excel-Step-8-Version-2.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-8-Version-2.jpg\" decoding=\"async\" width=\"728\" height=\"543\" class=\"whcdn\" /></a></div>\n</li>\n<li>Unfreeze your cells. If you want to unlock the frozen cells, click the <b>Freeze Panes</b> menu again and select <b>Unfreeze Panes</b>.<br />\n<div class=\"mwimg largeimage floatcenter \" style=\"max-width:728px\"><a target=\"_blank\" href=\"https://www.wikihow.com/Image:Freeze-Cells-in-Excel-Step-9-Version-2.jpg\" class=\"image\"><img alt=\"Freeze Cells in Excel Step 9 Version 2.jpg\" src=\"https://www.wikihow.com/images/thumb/f/f8/Freeze-Cells-in-Excel-Step-9-Version-2.jpg/aid4772447-v4-728px-Freeze-Cells-in-Excel-Step-9-Version-2.jpg\" decoding=\"async\" width=\"728\" height=\"546\" class=\"whcdn\" /></a></div>\n</li>\n</ol>\n<h2><span class=\"mw-editsection\"><span class=\"mw-editsection-bracket\">[</span><a target=\"_blank\" href=\"https://www.wikihow.com/index.php?title=Freeze-Cells-in-Excel&amp;action=edit&amp;section=4\" title=\"Edit section: References\">Edit</a><span class=\"mw-editsection-bracket\">]</span></span><span class=\"mw-headline\" id=\"References\">References</span></h2>\n<h2><span class=\"mw-editsection\"><span class=\"mw-editsection-bracket\">[</span><a target=\"_blank\" href=\"https://www.wikihow.com/index.php?title=Freeze-Cells-in-Excel&amp;action=edit&amp;section=5\" title=\"Edit section: Quick Summary\">Edit</a><span class=\"mw-editsection-bracket\">]</span></span><span class=\"mw-headline\" id=\"Quick-Summary\">Quick Summary</span></h2>\n<div class=\"mw-references-wrap\">\n<ol class=\"references\">\n<li id=\"_note-1\"><a target=\"_blank\" href=\"#_ref-1\">↑</a> <span class=\"reference-text\"><a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external free\" href=\"https://support.office.com/en-us/article/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f\">https://support.office.com/en-us/article/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f</a></span>\n</li>\n<li id=\"_note-2\"><a target=\"_blank\" href=\"#_ref-2\">↑</a> <span class=\"reference-text\"><a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external free\" href=\"https://www.timeatlas.com/excel-freeze-panes/\">https://www.timeatlas.com/excel-freeze-panes/</a></span>\n</li>\n</ol>\n</div>\n</div>\n', created = 1618825309, expire = 1618911709, headers = '', serialized = 0 WHERE cid = '2:05ad70f8da2b2c600648fea0a4229c60' in /var/www/vhosts/tipsformom.com/httpdocs/includes/cache.inc on line 108.

This wikiHow teaches you how to freeze specific rows and columns in your Microsoft Excel worksheet. Freezing rows or columns ensures that certain cells remain visible as you scroll through the data. If you want to easily edit two parts of the spreadsheet at once, splitting your panes will make the task much easier.

[Edit]Steps

[Edit]Freezing the First Column or Row

  1. Click the tab. It's at the top of Excel. Frozen cells are rows or columns that remain visible while you scroll through a worksheet.[1] If you want column headers or row labels to remain visible as you work with large amounts of data, you'll likely find it helpful to lock those cells into place.
    Freeze Cells in Excel Step 1 Version 3.jpg
    • Only whole rows or columns can be frozen. It is not possible to freeze individual cells.
  2. Click the button. It's in the "Window" section of the toolbar. A set of three freezing options will appear.
    Freeze Cells in Excel Step 2 Version 3.jpg
  3. Click or . If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row. To keep the first column in place as you scroll horizontally, select Freeze First Column.
    Freeze Cells in Excel Step 3 Version 3.jpg
  4. Unfreeze your cells. If you want to unlock the frozen cells, click the Freeze Panes menu again and select Unfreeze Panes.
    Freeze Cells in Excel Step 4 Version 3.jpg

[Edit]Freezing Multiple Columns or Rows

  1. Select the row or column after those you want to freeze. If the data you want to keep stationary takes up more than one row or column, click the column letter or row number after those you want to freeze. For example:
    Freeze Cells in Excel Step 5 Version 3.jpg
    • If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, click row 4 to select it.
    • If you want columns A and B to remain still as you scroll sideways through your data, click column C to select it.
    • Frozen cells must connect to the top or left edge of the spreadsheet. It's not possible to freeze rows or columns in the middle of the sheet.[2]
  2. Click the tab. It's at the top of Excel.
    Freeze Cells in Excel Step 6 Version 2.jpg
  3. Click the button. It's in the "Window" section of the toolbar. A set of three freezing options will appear.
    Freeze Cells in Excel Step 7 Version 2.jpg
  4. Click on the menu. It's at the top of the menu. This freezes the columns or rows before the one you selected.
    Freeze Cells in Excel Step 8 Version 2.jpg
  5. Unfreeze your cells. If you want to unlock the frozen cells, click the Freeze Panes menu again and select Unfreeze Panes.
    Freeze Cells in Excel Step 9 Version 2.jpg

[Edit]References

[Edit]Quick Summary


Powered by Drupal - Design by artinet