How To Freeze A Column In Excel

When you scroll across a wide spreadsheet, your column headings disappear, making it hard to know what each value means. Freezing a column keeps it locked on screen while you move through the rest of your data, so you can always see the labels that matter. This guide shows you the quickest ways to freeze one column, or several, on both Windows and Mac, and how to undo it safely.

Fast Answer

Freeze first column: View tab → Freeze Panes → Freeze First Column
Freeze two or more columns: Select next column → View tab → Freeze Panes → Freeze Panes

1 minute Time needed

Beginner Difficulty

Hidden freeze lines Watch out for

Before You Start

A computer with Microsoft Excel installed (Microsoft 365, Excel 2021, Excel 2019, or Excel 2016 all work the same way).
The spreadsheet file you want to edit, saved somewhere you can find it.
About 1 minute of time — freezing panes is instant and does not require saving before you start.
A basic understanding of which column contains your labels. Usually this is column A, but not always.

Check first: Freezing panes only works in the normal worksheet view. If you are in Page Layout view or Full Screen view, the Freeze Panes option will be greyed out or hidden. Switch back to Normal view from the View tab before you start.

Step-by-Step Instructions

Decide which column you need to lock

Before you touch any menus, work out what you are trying to achieve. The most common need is to freeze the first column (column A) so that row labels stay visible when you scroll horizontally to columns like M or N.

If you have a table where the first two columns contain identifying information, such as a customer ID in column A and a name in column B, you may want to freeze both. The method for that is different from the one-click approach, so it helps to decide in advance.

Tip: Think of freezing as an anchor. Excel locks everything above and to the left of the cell you select before freezing. That is the secret to controlling exactly what stays put.

Freeze just the first column

This is the fastest method and covers most people's needs. Click the View tab on the ribbon near the top of the Excel window. Look for the Freeze Panes button, which sits in the Window group. Click it, and from the dropdown menu choose Freeze First Column.

A thin grey or dark line will appear to the right of column A. That line is your visual cue that the column is locked. You can now scroll horizontally through the rest of your data, and column A will stay glued to the left edge of the screen.

Tip: The Freeze First Column option only ever freezes a single column. If you have already frozen rows and then choose Freeze First Column, Excel will clear the row freeze and replace it with the column freeze. You cannot mix the one-click options.

Freeze multiple columns

If you need to freeze two or more columns, you must use the main Freeze Panes option rather than the shortcut. First, click on the cell that is immediately to the right of the columns you want to freeze. For example, if you want to freeze columns A and B, click on cell C1 (or any cell in column C, but row 1 is easiest to see).

Go back to the View tab, click Freeze Panes, and select the first option, also called Freeze Panes. Excel will draw a vertical freeze line to the left of column C, which means columns A and B are now locked. Scroll right and you will see those two columns remain on screen.

Important: The cell you select determines everything. If you click on cell B1 intending to freeze column A, but actually you wanted columns A and B, you will only freeze column A. Double-check the selected cell before you choose Freeze Panes.

Freeze columns and rows together

Large spreadsheets often need both row headings and column headings locked at the same time. For instance, you might want row 1 (the month headers) and column A (the item names) to stay visible no matter where you scroll.

To do this, click on the cell that is just below the row and just to the right of the column you want frozen. That means selecting cell B2 if you want row 1 and column A frozen. Then go to View tab, click Freeze Panes, and choose Freeze Panes from the dropdown. Excel will place two freeze lines: one horizontal above row 2 and one vertical left of column B.

Tip: This is the technique that makes large dashboards and reports usable. If you can see your headings and your row labels at the same time, you can navigate hundreds of rows or columns without getting lost.

Check that your freeze is working

After applying any freeze, take a moment to verify it. Press the right arrow key several times or drag the horizontal scroll bar at the bottom of the window. Your chosen column or columns should remain visible on the left while the other columns slide underneath.

Then test the vertical scroll. If you froze rows as well, scroll down through several rows and confirm that the top row stays in place. If the freeze line does not exist, or the column still moves, you may have selected the wrong cell before freezing.

Check first: Freeze lines are only visible when you scroll. If you are at the very beginning of your sheet, and the left edge of column A is already at the screen edge, you may not see a visible line, but the freeze is still active.

Freeze a column in Excel on a Mac

The process is almost identical on a Mac, but the ribbon layout differs slightly. Open your spreadsheet and click the View tab at the top of the Excel window. You will see a Freeze Panes button in the Window group, just as on Windows.

Click the dropdown arrow next to Freeze Panes and you will see the same three options: Freeze Panes, Freeze Top Row, and Freeze First Column. The selection rules are the same as on Windows — click the cell below and to the right of the area you want locked before choosing Freeze Panes.

Tip: If you are using an older version of Excel for Mac, the Freeze Panes options may be under the Window menu at the top of the screen instead of a View tab. Look for a menu item called Freeze Panes rather than a button.

Unfreeze columns when you are done

When you no longer need the frozen columns, removing them is just as simple. Go to the View tab, click the Freeze Panes button, and choose Unfreeze Panes from the bottom of the dropdown menu.

This clears all frozen rows and columns at once. You cannot selectively unfreeze one column while keeping another frozen — it is an all-or-nothing action. After unfreezing, your spreadsheet returns to normal scrolling behaviour.

Heads up: Unfreeze Panes only appears when a freeze is already active. If you do not see it in the menu, then nothing is currently frozen.

Use the keyboard shortcut for speed

For frequent Excel users, the mouse-based method can feel slow. There is a keyboard shortcut that opens the Freeze Panes menu quickly. Press Alt + W + F on a Windows keyboard. This activates the View tab, then opens the Freeze Panes dropdown.

From there, you can press F to freeze the first column, R to freeze the top row, or press Enter to apply the standard Freeze Panes option using your selected cell. On a Mac, the shortcut is Option + Command + F to open the Freeze Panes dropdown.

Tip: If you use Freeze Panes frequently, this shortcut saves a lot of time. After using it a few times, you will not need to look at the ribbon at all.

Quick Reference

Situation	Use this	Why
One column locked	View tab → Freeze Panes → Freeze First Column	Fastest way to keep column A visible
Two or more columns locked	Select next column → View tab → Freeze Panes → Freeze Panes	Locks everything to the left of the selected cell
Rows and columns together	Select cell below and right of freeze point → Freeze Panes	Keeps headings and labels visible at once
Remove all freezes	View tab → Freeze Panes → Unfreeze Panes	Resets the sheet to normal scrolling

Common Problems When You Freeze a Column in Excel

The Freeze Panes button is greyed out

This usually happens when you are in a view other than Normal. Switch to Page Layout view back to Normal by clicking the Normal button in the bottom-right corner of the Excel window, or go to the View tab and click Normal. Then the Freeze Panes option will become available.

You froze the wrong column

If you selected cell B1 intending to freeze column A, but you wanted columns A and B frozen, you need to unfreeze and start again. Click Freeze Panes, choose Unfreeze Panes, then select the correct cell and apply the freeze again. This error is common but easy to fix.

The freeze line is invisible

If you are at the very left edge of your spreadsheet and column A is already at the screen edge, you will not see a vertical freeze line. Scroll right a few columns and the line should appear to the left of your frozen column. If it still does not appear, the freeze may not have been applied.

Freezing works on rows but not columns

This happens when you use the Freeze Top Row option, which only affects row 1. If you need a column freeze as well, you must use the full Freeze Panes option and select the correct cell first. The one-click options cannot be combined.

Your frozen column scrolls away after you close the file

Freeze settings are saved with the workbook, so they should persist when you close and reopen the file. If they do not, you may be opening the file in a different Excel version or the sheet may be protected. Check that you saved the file after applying the freeze.

Advanced Tips for Freezing Columns in Excel

Once you master basic freezing, you can take control of large spreadsheets even further. Here are some techniques that go beyond the simple freeze.

Use Excel Tables for automatic frozen headers

If you convert your data range into a table (select the data, then press Ctrl + T on Windows or Control + T on a Mac), Excel automatically keeps the header row visible as you scroll, even without using Freeze Panes. This only works for rows, not columns, but it is a clean alternative if your main issue is losing column headers.

Split panes to compare distant columns

Splitting is related to freezing but works differently. On the View tab, click Split. This divides your window into separate panes, each with its own scroll bar. You can use one pane to view column A while another pane shows column Z, without freezing anything. This is great for comparing data that is far apart.

Freeze with a custom view for different tasks

You can save different freeze setups as custom views. Go to the View tab, click Custom Views, then Add. Name the view, like "Freeze Columns" or "Freeze Rows Only," and save. Later, you can switch between views instantly without reapplying the freeze settings each time.

Pro tip: Before printing a report, you can use freeze panes to make sure the printout includes repeating column headings. On the Page Layout tab, click Print Titles and set the Columns to repeat at left. This is a print-only setting that does not affect the on-screen freeze.

How To Freeze A Column In Excel FAQ

Common Issues

If the result is not working as expected, return to the previous step, check the material or setting involved, and make one adjustment at a time for how to freeze a column in excel.

Can I freeze both a row and a column at the same time?

Yes. Select the cell that is just below the row and just to the right of the column you want frozen, then go to View tab, click Freeze Panes, and choose Freeze Panes. For example, selecting cell B2 freezes row 1 and column A.

Why is my Freeze Panes option not working?

The most common cause is being in Page Layout view. Switch to Normal view from the View tab, and the Freeze Panes option will become active. Another possible cause is that your sheet is protected, which disables freeze controls.

Does freezing a column affect printing?

No. Freeze panes only affects what you see on screen. If you want a column to repeat on every printed page, use the Print Titles option in the Page Layout tab instead.

How do I freeze more than one column?

Select the cell immediately to the right of the columns you want frozen. For example, to freeze columns A and B, select cell C1. Then go to View tab, click Freeze Panes, and choose Freeze Panes.

Can I freeze a column in Excel Online or Google Sheets?

Excel for the web has the same Freeze Panes options under the View tab. In Google Sheets, you can freeze columns by selecting a cell and then using the View menu or dragging the grey freeze bar at the top left of the sheet.

Is there a shortcut to unfreeze panes?

There is no single-key shortcut, but you can press Alt + W + F + U on Windows to open the Freeze Panes menu and select Unfreeze Panes. On a Mac, use Option + Command + F to open the dropdown.

Final Checklist for Freezing a Column in Excel

Decided exactly which column or columns need to stay visible
Confirmed you are in Normal view
Used Freeze First Column for a single column
Used the full Freeze Panes option for multiple columns or rows
Selected the correct cell before applying the freeze
Tested horizontal scrolling to confirm the column stays locked
Tested vertical scrolling if you also froze rows
Saved your file so the freeze is stored with the workbook
Unfroze panes when you no longer needed them

Next action: Open your most data-heavy spreadsheet and freeze the column that contains your key identifiers. You will immediately notice how much easier it is to read across the sheet without losing your place.