Skip to content

How to Freeze/Lock Rows and Columns in Excel

< 1 minute read

lt green cloud

Are you familiar with the Freeze Panes functionality in Excel 2013/2016?

Freeze Panes has been around for awhile, and you’ve most likely seen or worked with a spreadsheet with a frozen top row or columns, but it can be easy to forget how to do it even if you’ve learned how before.

Check out the video above, or follow these steps:

  1. Go to the View tab.
  2. To freeze or lock your top row, click the Freeze Panes icon in the ribbon and select Freeze Top Row.
  3. To freeze or lock your first column, click the Freeze Panes icon and select Freeze First Column.
  4. To freeze multiple rows at the top of the spreadsheet, or columns on the left of the spreadsheet, select a column just below or just to the right of where you’d like to freeze. Click the Freeze Panes icon and select Freeze Panes.

Freeze panes in Excel 2013

Sign up for our newsletter