How to Freeze a Column and a Row in Excel at the Same Time: One-Click Lock for Headers

I lost an entire afternoon to scrolling through a massive spreadsheet once. That’s when I discovered Excel’s freeze panes feature—one click to lock both headers and first column in place.

No more guessing which row or column you’re looking at while scrolling. The trick is selecting the right cell before freezing—usually the one just below your headers and to the right of your first column.

You’ll keep your bearings no matter how far you scroll, and the setup takes under 10 seconds. Works in all modern Excel versions, from 2016 to 365.

Here’s where it gets interesting—most users stop at freezing just rows or columns, but locking both is even more powerful for large datasets.

What Youll Need

Instructions

Here’s the method I use to lock both headers in place without any fuss.

Launch Excel and open the worksheet containing your data. Locate the cell where your data begins—typically A1 for standard tables, but it could be any cell if your headers are offset. I always double-check this because freezing the wrong cell can make navigation more difficult, not easier.

Look at the row and column headers. The goal is to freeze everything above and to the left of your data’s starting point. For example, if your headers are in row 1 and column A, you’ll freeze the top row and first column.

Click on the cell directly below your row header and to the right of your column header. If your headers are in row 1 and column A, this would be B2. This tells Excel where the freeze line begins.

If your headers span multiple rows or columns, select the cell where the actual data starts. For instance, if you have two header rows and one header column, click B3. This ensures all headers remain visible as you scroll.

Go to the View tab on the ribbon. In the Window group, click Freeze Panes. A dropdown menu appears with three options: Freeze Panes, Freeze Top Row, and Freeze First Column.

Select Freeze Panes. Excel will now lock all rows above and columns to the left of your selected cell. You’ll see a thin gray line appear below your row header and to the right of your column header, indicating the freeze boundary.

Scroll down and to the right in your worksheet. The row headers should remain visible at the top, and the column headers should stay fixed on the left. If they don’t, you likely selected the wrong cell in Step 2.

To unfreeze, return to View > Freeze Panes and select Unfreeze Panes. This removes all freeze lines and restores normal scrolling behavior.

For worksheets with multi-level headers, the process is identical. Suppose you have headers in rows 1-3 and columns A-C. Select D4, then apply Freeze Panes. This keeps all header rows and columns locked while allowing the data area to scroll freely.

If you need to change the freeze point later, simply unfreeze first, then select a new cell and reapply the freeze. Excel doesn’t allow multiple independent freeze zones, but this method covers most use cases perfectly.

Tips and Common Mistakes

Here are the key details that make this Excel technique foolproof every time.

The Selection Secret: In Step 2, choosing the right cell is everything. If your headers are in row 1 and column A, B2 is your target. For multi-level headers like rows 1-3 and columns A-C, it’s D4. I’ve seen users select the header cell itself and wonder why nothing freezes—always pick the cell where your actual data begins.

Visual Confirmation: After applying Freeze Panes in Step 3, look for that thin gray line—it’s your confirmation that the freeze worked. If you don’t see it, you either selected the wrong cell or clicked the wrong option. The line should appear below your last header row and to the right of your last header column.

Complex Layouts: For Step 5 scenarios with multi-level headers, remember the pattern: count your header rows and columns, then select the cell that’s one row down and one column right from the last header. This works for any configuration, whether it’s rows 1-5 and columns A-B or any other combination.

Undo Strategy: If your headers don’t stay fixed when scrolling in Step 4, don’t panic. Just go back to View > Freeze Panes > Unfreeze Panes, then retry from Step 2. Most mistakes happen because the initial cell selection was off by one row or column.

Frequently Asked Questions

Freezing both a column and a row in Excel is a simple yet powerful way to keep your headers visible while scrolling. With just a few clicks, you can lock your top row and leftmost column simultaneously for better data navigation. Now that you’ve mastered this trick, try applying it to your next spreadsheet to boost productivity! 🎯