How to Freeze Cells in Excel – 4 Easy Examples

Recently, I helped a friend with an Excel project. When I asked my friend how the spreadsheet looked, he hesitated. Never a good sign. He looked at me and said, “It’s too complicated.” It turns out the data was fine, but he wanted an “Excel sticky row.” I needed to show him how to freeze rows and columns in Excel, so key information was always visible when he scrolled the worksheet.

This was a good lesson for me. It reminded me that we all have different experience levels. For example, when you’re new to Excel, you’re probably not going to think in terms of “freeze panes.” It’s not describing your problem. My friend was thinking in terms of “sticky header” or “Excel floating header.”

Why Lock Cells

A benefit to locking or freezing cells is you always see the important information regardless of scrolling. Otherwise, it’s easy to lose context on large spreadsheets when you don’t have headings or identifiers. I’ve had times where I’ve entered data only to discover I was one cell off.

Typically, the cells you want to stay sticky are labels like column headings. They could just as easily be an entire column, such as employee names. And in some cases, you may want to lock both columns and rows.

Let’s go through some freeze panes examples.

Example 1 – How to Freeze Top Row

This is perhaps the most common example because people like to lock the top row that contains column headers, such as in the example below. Another solution is to format the spreadsheet as an Excel table.

Locked header row.
Locking the Top Row with Headings
  1. Open your worksheet.
  2. Click the View tab on the ribbon.
  3. On the Freeze Panes button, click the small triangle in the lower right corner. You should get a new menu with 3 options.
Freeze Panes button drop down with 3 Freeze Pane Options.
The Main Freeze Pane Options
  1. Click the option Freeze Top Row.
  2. Scroll down your sheet to make sure the first row stays locked at the top.

You should see a darker horizontal line underneath the first row.

Keyboard Shortcut – Lock Top Row

I like to do this shortcut slowly the first time to see the letter assignments as you type. In the example below, once I hit my Alt, I can see the keyboard assignments. Some people prefer to add the Freeze Panes command to the Quick Access toolbar because they frequently use it.

Keyboard shortcut letters apper after hitting ALT
Keyboard Shortcut Letters

Alt + w + f + r

Example 2 – How to Lock the First Column

A similar scenario is when you want to freeze a column. Again, it’s often the first column. My guess is Microsoft did research on this to figure out the most common options on that sub-menu.

I find this option helpful when I have a spreadsheet with many columns and I need to fill in data.

Freezing the first Excel column.
Freeze first column of Excel
  1. Open your Excel worksheet.
  2. Click the View tab on the ribbon.
  3. On the Freeze Panes button, click the keyboard_arrow_down small triangle in the lower right corner. You should get a new menu with your 3 options.
  4. Click the option Freeze First Column.
  5. Scroll across your sheet to make sure the left column stays fixed.

Keyboard Shortcut – Lock First Column

Alt + w + f + c

Example 3 – How to Freeze Top Row & First Column

Column 1 and row 1 are frozen.
Think of “Freeze Pane” in terms of rows & columns

This is my favorite freeze pane option. If you look at the initial Freeze Panes options from Microsoft, there isn’t one for both the top row and first column. Instead, we’ll use the generic option called Freeze Panes.

The subtext reads, “Keep rows and columns visible while the rest of the worksheet scrolls (based on current selection).” Some folks get confused as they think they have to highlight data to make a selection.

Instead, think of the selection as the first cell outside of your fixed column and row. If I wanted to lock the top row and top column, that selection cell would be B2 or Nevada. Regardless of whether I scroll down or to the right, the first cell that disappears is B2.

Freeze Pane Selection Cell.
The Freeze Pane Selection Cell
  1. Open your Excel spreadsheet.
  2. Click cell B2.
  3. Click the View tab on the ribbon.
  4. On the Freeze Panes button, click the small triangle in the lower right corner. You should get a new menu with your 3 options.
  5. Click the option Freeze Panes.
  6. Scroll down your worksheet to make sure the first row stays at the top.
  7. Scroll across your sheet to make sure your first column stays locked on the left.

Keyboard Shortcut – Freeze Panes

Alt + w + f + f

info Make sure you clicked a cell first.

Example 4- Lock Multiple Columns or Rows

On occasion, I get some Excel worksheets where the author puts descriptive text above the data. My column headers aren’t in Row 1 but further down. Or, I need to lock multiple columns on the left. In the example below, I want to lock Columns A & B and Rows 1-5.

Freeze Pane with Multiple Columns & Rows.
Example of Freeze Pane with Multiple Columns & Rows

The process is the same, I just need to click the cell that stops the fixed area. In this case, it would be cell C6 or “Regions Field.”

Another way to think of this is the cell that is in the top left corner of where your locked rows and locked columns meet. The content above and to the left is frozen.

Everything in the red boxes would be locked. The downside is you may be giving up a lot of the screen real estate.

Quick Caveats

There are some rules surrounding this feature:

  • If you don’t like your settings, you can use Unfreeze Panes command.
  • This feature won’t work on a protected worksheet or Page Layout View.
  • If you’re editing a value in the Formula bar, the View menu will be disabled.
Excel 2019 All-in-One For Dummies
Harvey, Greg (Author); English (Publication Language); 816 Pages - 10/26/2018 (Publication Date) - For Dummies (Publisher)
$18.99

Disclaimer: Images from Amazon Product Advertising API. I may receive an affiliate commission on these products if you buy. Updated: 2021-03-07