How to Freeze Panes 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 what he wanted was an “Excel sticky header.” 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 and terminology. For example, when you’re new to Microsoft Excel, you’re probably not going to think in terms of “how to freeze panes.” It’s not describing your problem. My friend was thinking in terms of “sticky header” or “Excel floating header.”

When it comes to spreadsheets, you can “freeze panes” or “split panes“. Splitting panes is a bit more complex because you have multiple views of your data on the worksheet. So, for the sake of simplicity, this tutorial will cover freezing panes.

Why Lock Spreadsheet Cells

A benefit to locking or freezing cells is you see the important information regardless of scrolling. The split pane data stays fixed. Your spreadsheet can contain panes with column headings, multiples rows, multiple columns, or both.

Otherwise, it’s easy to lose focus on a large worksheet when you don’t have column headings or identifiers. I’ve had times where I’ve entered data only to discover I was one cell off and produced Excel formula errors.

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

Let’s go through some freeze panes examples.

1 – How to Freeze Top Row

This freeze row example is perhaps the most common 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.Pin
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 Excel downward triangle.. You should get a new menu with 3 options.
Freeze Panes button drop down with 3 Freeze Pane Options.Pin
The Main Freeze Panes 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 key, 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

2 – How to Lock 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 and don’t want to use an Excel data form.

Freezing the first Excel column.Pin
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 small triangle Excel downward 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

3 – How to Freeze Top Row & First Column

Column 1 and row 1 are frozen.Pin
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.Pin
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

Make sure you clicked a cell first.

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.Pin
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 follow these, you may find freeze panes doesn’t work.

  • 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.

As you’ve seen, it’s easy to freeze panes in Excel. You can freeze the top row, first column, both, or a subset of your data, depending on what you want to do with it. The flexibility is part of what makes Microsoft Excel such an excellent program for organizing and analyzing information from any field.