How to Freeze First Column in Excel: 4 Simple Tricks to Never Lose Row Labels Again
Learning how to freeze first column in excel takes less than a minute. You scroll right to see a far column, and the names in column A slide out of view. This guide shows four simple tricks that keep column A on screen.
Microsoft Excel is the spreadsheet app from Microsoft. It first appeared for the Apple Macintosh on September 30, 1985, and the first Windows version followed on November 19, 1987. A worksheet can hold up to 1,048,576 rows by 16,384 columns, so wide tables are normal in real work. The steps below work in Microsoft Excel for Microsoft 365 on Windows and on Mac.
To freeze the first column in Excel, open the worksheet, click the View tab, click Freeze Panes, and choose Freeze First Column. Column A stays visible while you scroll right, and a thin line appears to the right of column A. To remove the freeze, go to View, click Freeze Panes, and choose Unfreeze Panes.
ANSWER BOX 1
To freeze the first column in Excel, click the View tab at the top of the screen. Click Freeze Panes in the Window group, then choose Freeze First Column from the menu. A thin vertical line appears to the right of column A. Scroll right now, and column A stays in place while the other columns move.
ANSWER BOX 2
Freeze First Column locks column A only, and it works no matter which cell you have selected. It does not lock the top row, and it does not lock any other column. If you also need row 1 to stay visible, select cell B2 first and use Freeze Panes instead.
KEY TAKEAWAYS
- How to freeze first column in excel starts on the View tab, with Freeze Panes and then Freeze First Column.
- The command locks column A only, and it ignores which cell you have selected.
- Alt, W, F, C is the fast Windows shortcut for the same one click command.
- Select cell B2 and use Freeze Panes when you need row 1 and column A together.
- Unfreeze Panes on the View tab removes the freeze, and it never deletes your data.
Contents
- What does freeze first column mean in Excel?
- How to freeze first column in Excel in 4 simple tricks
- How to freeze first column and top row together in Excel
- How to use the frozen first column with wide tables and filters
- Freeze first column vs freeze panes: which one should you use?
- How to check your freeze and how to unfreeze it
- 4 mistakes that make you lose your row labels
- FAQ
What Does Freeze First Column Mean in Excel?
Freezing the first column means column A stays on the left side of your screen while you scroll right. The rest of the sheet moves as normal, and column A acts like a fixed label strip for every row. That match is the whole point of the tool, and it is why wide tables feel easier with a freeze in place.
The freeze changes only what you see on screen, and it does not change your data in any way. It does not lock cells against edits, it does not hide columns, and it does not change how the sheet prints. Microsoft Support describes Freeze Panes as a view tool that locks rows, columns, or both to the top and left of a sheet. Our pillar guide on how to freeze panes in excel explains the full freeze system.
How to Freeze First Column in Excel in 4 Simple Tricks
These four tricks cover the same result by four different paths, so pick the one that fits your device and your habit. The first trick is the standard menu path, the second is the fast keyboard path for Windows, the third is the Mac path, and the fourth locks the top row as well.
Trick 1: Use the one-click Freeze First Column command on Windows
Open your worksheet and click the View tab at the top of the Excel window. Find the Freeze Panes button in the Window group, and click the small arrow under it to open the menu. Choose Freeze First Column, and Excel locks column A at once. A thin vertical line appears to the right of column A, and that line marks the edge of the frozen area.
Trick 2: Use the keyboard shortcut Alt, W, F, C on Windows
Press Alt, then W, then F, then C, one key after another, and do not hold them down together. Excel reads the keys as a ribbon path: Alt opens the ribbon keys, W opens the View tab, F opens the Freeze Panes menu, and C picks Freeze First Column. The same thin line appears to the right of column A, and the result matches Trick 1 exactly. This path is the fastest option when you freeze columns many times a day, because your hands never leave the keyboard.
Trick 3: Freeze the first column in Excel on a Mac
Open the worksheet on your Mac and click the View tab in the ribbon at the top. Microsoft Support for Mac lists Freeze First Column as a button on the View tab, so look for it in the Window area of that tab. Click Freeze First Column, and the line to the right of column A turns a little darker than the other grid lines. If the freeze buttons look grey, select Normal on the View tab first, because Freeze Panes does not work in Page Layout view. Our guide on how to unfreeze panes in excel covers the Mac unfreeze path step by step.
Trick 4: Freeze the first column when your labels start in another column
Freeze First Column always locks column A, even if your real labels sit in column B or column C. Move the label column to column A first, or use the general Freeze Panes command to set your own edge. To move a column, select its heading, hold Shift, and drag its border to the left of column A. If you cannot move the column, select the cell just to the right of the last column you want to keep, then use Freeze Panes.
How to Freeze First Column and Top Row Together in Excel
Freeze First Column locks column A only, and Freeze Top Row locks row 1 only, so neither command alone can hold both edges. Choosing one after the other does not stack them, because the second choice replaces the first. You need the third command in the menu, which is the plain Freeze Panes choice, and you need to select cell B2 first.
Select cell B2 first. Go to the View tab, click Freeze Panes, and choose Freeze Panes from the top of the menu. Excel freezes every row above B2 and every column to the left of B2, so row 1 and column A stay on screen together. Our guide on how to freeze top row in excel covers the row only path in full detail.
| What you want to keep | Cell to select first | Command to use |
|---|---|---|
| Column A only | Any cell | Freeze First Column |
| Row 1 only | Any cell | Freeze Top Row |
| Row 1 and column A | Cell B2 | Freeze Panes |
| Columns A and B | Cell C1 | Freeze Panes |
How to Use the Frozen First Column With Wide Tables and Filters
A frozen first column helps most on a wide table, where the columns run far past the edge of the screen. First, make sure your labels really sit in column A, because a frozen column only helps when it holds the words you read by. Then apply the freeze from Trick 1 and test it.
Filters pair well with a frozen first column, because they narrow the rows while the labels stay visible. Click any cell inside your data, go to the Data tab, and click Filter to add small arrows to the header row. Use an arrow to show only one category or month, and the frozen column still shows the label for each row that remains. You can sort the table too, and the frozen column follows the sort.
Freeze First Column vs Freeze Panes: Which One Should You Use?
Freeze First Column and Freeze Panes sound alike, but they serve different needs, and the choice is simple once you see the split. Freeze First Column is a preset that locks column A only, with no cell choice and no extra setup. Freeze Panes is a free choice that locks the rows above and the columns to the left of the cell you select.
Microsoft 365 Consumer subscribers grew to 80.8 million in Microsoft’s Q3 FY2024 results, announced April 25, 2024, so this small choice sits inside a tool that millions use every day.
| Choice | What stays visible | When to use it |
|---|---|---|
| Freeze First Column | Column A only | Labels in column A, wide table, no header need |
| Freeze Top Row | Row 1 only | Headers in row 1, long table, no label need |
| Freeze Panes from B2 | Row 1 and column A | Most real tables with headers and labels |
| Freeze Panes from C1 | Columns A and B | Two label columns, such as code plus name |
How to Check Your Freeze and How to Unfreeze It
Check your freeze with a short scroll test before you trust it, because a quick test catches a wrong cell choice in seconds. Scroll right until column A is the only label column left on screen, and read a value in a far column against the name beside it. Scroll down as well if you used the B2 method, and check that row 1 still shows the headers. If the labels match the numbers, your freeze is correct.
To remove a freeze, go to the View tab, click Freeze Panes, and choose Unfreeze Panes from the menu. The thin lines vanish at once, and the sheet scrolls as normal again. The data stays exactly as it was, because unfreezing changes only the view. If Unfreeze Panes is missing, no freeze is active on that sheet. Our guide on freeze panes in excel not working covers the grey button and the protected sheet case.
4 Mistakes That Make You Lose Your Row Labels
These four mistakes cause most of the lost label pain in Excel, and each one has a simple fix.
- Freezing the wrong column by habit. Freeze First Column always locks column A, so it cannot lock column B on its own. Move your labels to column A first, or use Freeze Panes from the cell to the right of your labels.
- Stacking Freeze Top Row and Freeze First Column. The second command replaces the first, so you end with only one edge frozen. Select cell B2 and use Freeze Panes once instead.
- Freezing while you are in Page Layout view. Freeze Panes stays grey in that view, and the menu will not run. Switch to Normal view on the View tab, then apply the freeze again.
- Forgetting that a freeze is a view aid only. A frozen column does not lock cells, does not stop edits, and does not repeat on printed pages. Use sheet protection to lock cells, and use Print Titles for paper.
How to Freeze First Column in Excel FAQ
How do I freeze the first column in Excel?
Click the View tab, click Freeze Panes, and choose Freeze First Column. Column A stays visible while you scroll right.
How do I freeze the first column and the top row at the same time?
Select cell B2, go to View, click Freeze Panes, and choose Freeze Panes.
What is the shortcut to freeze the first column in Excel?
Press Alt, then W, then F, then C, one key after another on Windows.
How do I freeze the first column in Excel on a Mac?
Open the View tab and click Freeze First Column. The line to the right of column A turns darker, which means the freeze is active.
Why is Freeze First Column greyed out in Excel?
The command stays grey in Page Layout view, while you edit a cell, or on a protected sheet. Switch to Normal view, finish the edit, or unprotect the sheet and try again.
Can I freeze two columns in Excel?
Yes, but Freeze First Column cannot do it, because it locks column A only. Select cell C1, go to View, click Freeze Panes, and choose Freeze Panes.
Does freezing the first column lock the cells?
No, freezing only changes what stays on screen while you scroll. You can still type in column A and edit any cell in the sheet.
How do I unfreeze the first column in Excel?
Go to the View tab, click Freeze Panes, and choose Unfreeze Panes. The thin line beside column A vanishes, and the sheet scrolls as normal.
Does Freeze First Column work in Excel for the web?
Yes, Microsoft Support lists Excel for the web among the apps that support Freeze Panes.
Can I freeze the first column and keep filters working?
Yes, filters keep working with a frozen column, because freezing never locks your data order.
Will the frozen first column print on every page?
No, a screen freeze does not repeat on paper by itself. Go to Page Layout, click Print Titles, and set Columns to repeat at left to column A.
How do I know the freeze is working?
Scroll right and watch column A stay on the left while the other columns move. A thin line to the right of column A marks the frozen edge.
What if my labels are not in column A?
Move the label column to column A, or use Freeze Panes from the cell to the right of your labels.
Final Word
Learning how to freeze first column in excel is a one minute skill, and it pays off every time you open a wide table. Use the one click command for column A alone, use the Alt, W, F, C shortcut when you repeat the job, and use cell B2 with Freeze Panes when you need the top row too. Our guide on how to freeze top row in excel shows you the row path in full.
Read more about Microsoft Excel on Wikipedia: https://en.wikipedia.org/wiki/Microsoft_Excel


