How to Freeze (Lock in Place) a Cell in Excel

PDF download Download Article
PDF download Download Article

Freezing rows and columns in Microsoft Excel versions 2013, 2010, and 2007 can be helpful if you want to keep a section of your spreadsheet visible at all times while you move to and work in other sections of your document. Individual cells cannot be frozen and locked into place; however, you can freeze one or multiple rows and columns located at the very top and left sides of your spreadsheet, respectively.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-1-Version-2.jpg\/v4-460px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/fe\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-1-Version-2.jpg\/aid4291273-v4-728px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    For example, if you want to freeze row 1, select row 2.
    • When freezing a row(s) and column(s) at the same time, click on the one cell located just below and to the right of the row(s) and column(s) you want frozen. For example, if you want to freeze row 1 and column A, click on the cell located in B2.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fd\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-2-Version-2.jpg\/v4-460px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/fd\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-2-Version-2.jpg\/aid4291273-v4-728px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/52\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-3-Version-2.jpg\/v4-460px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/52\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-3-Version-2.jpg\/aid4291273-v4-728px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1d\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-4-Version-2.jpg\/v4-460px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/1\/1d\/Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-4-Version-2.jpg\/aid4291273-v4-728px-Freeze-%28Lock-in-Place%29-a-Cell-in-Excel-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    The row(s) and/or column(s) you have selected will now be frozen in place. [1]
    • Select “Freeze Panes” when freezing a row(s) and column(s) at the same time.
    5. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      • Freeze certain rows or columns that contain labels to make working in your spreadsheet an easier task. Freezing rows or columns with labels will allow you to scroll down or over to another section of the spreadsheet and continue working without losing sight of your labels.
        Thanks
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • You will not have the ability to freeze rows, columns, or panes if your spreadsheet is protected or if you are editing a particular cell. To gain access to the freeze pane feature, remove the protection from your spreadsheet, or finish editing a cell.
        Thanks
      • If using Excel Starter, you will not have the ability to freeze and lock rows and columns as a result of feature limitations in this particular version of Excel. To gain access to the freeze pane feature, you will be required to work in an alternate version of Excel.
        Thanks
      Advertisement

      You Might Also Like

      How to
      Sort Microsoft Excel Columns Alphabetically
      How to
      Lock Cells in Excel
      How to Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Type Formulas in Microsoft Excel
      How to
      Recover a Corrupt Excel File
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      Advertisement

      References

      1. ↑ http://office.microsoft.com/en-us/excel-help/freeze-rows-and-columns-HA102749015.aspx

      About This Article

      Thanks to all authors for creating a page that has been read 49,730 times.

      Is this article up to date?

      Advertisement