Learn how to lock columns in Excel the right way: freeze panes to keep columns visible while you scroll, then use sheet protection to lock cells when you need
Most people searching for how to lock columns in Excel aren't trying to stop anyone from editing the data — they just want the column with employee names or project IDs to stay on screen while they scroll right. That's the confusion behind "lock columns in Excel," and it's worth naming upfront: there are two completely different features here, and mixing them up makes your spreadsheet harder to use, not easier.
Freeze Panes is a visibility fix. It keeps one or more columns anchored to the left side of your screen no matter how far right you scroll. Protect Sheet is a permissions fix. It stops people from editing cells you've marked as locked. Both are useful. Neither is a substitute for the other. The fastest way to get comfortable with Excel — whether you're preparing for a job interview or just trying to share a clean spreadsheet with a colleague — is to understand which problem each feature actually solves.
What People Mean When They Say They Want to Lock Columns in Excel
Freeze the view, not the data
Imagine you're working with an employee roster. Column A has employee names, Column B has employee IDs, and Columns C through P have attendance data, salary bands, review scores, and department codes. When you scroll right to check the review scores in Column N, the names and IDs disappear off the left edge of the screen. You're now staring at numbers with no context for who they belong to.
That's a visibility problem. The data isn't going anywhere — it's still there, just off-screen. What you want is for Columns A and B to stay visible no matter how far right you scroll. Freeze Panes does exactly that. It doesn't touch the data, doesn't restrict editing, and doesn't require a password. It just pins columns to the left side of your view.
Why the wrong fix makes the sheet harder to use
Protecting the sheet sounds like the responsible choice, especially if you've heard it described as "locking" the spreadsheet. But if you apply worksheet protection when your real goal is just keeping names visible, you'll end up with a sheet where nobody can edit anything — including the cells they're supposed to update — and the names still disappear when you scroll right.
Microsoft's own documentation draws a clear line between Freeze Panes (a display feature) and worksheet protection (a permissions feature). They live in different menus, solve different problems, and should be applied in a specific order when you need both. Freeze Panes is on the View tab. Protect Sheet is on the Review tab. That separation is intentional.
Freeze the First Column Before You Touch Anything Else
The one-click path most beginners miss
Freezing the first column in Excel takes about three seconds and requires no cell selection at all. Open the workbook, click the View tab in the ribbon, click Freeze Panes in the Window group, and select Freeze First Column from the dropdown. That's it. A thin vertical line appears between Column A and Column B to show the freeze is active.
Most beginners either don't know this option exists or assume they need to select the column first. You don't. The "Freeze First Column" option is specifically designed to work without any prior selection, which makes it the fastest path for the most common use case: keeping your label column visible while you scroll through data to the right. Use freeze panes in Excel this way whenever you have a single identifier column — names, IDs, SKUs, project codes — that needs to stay anchored.
What the steps look like in practice
Here's the exact desktop Excel walkthrough:
- Open your spreadsheet. Scroll right to confirm the problem — Column A disappears as soon as you move past the visible columns.
- Click the View tab at the top of the Excel ribbon.
- In the Window group (usually toward the right side of the View tab), click Freeze Panes.
- A dropdown appears with three options: Freeze Panes, Freeze Top Row, and Freeze First Column. Click Freeze First Column.
- A thin dark line appears between Column A and Column B.
- Scroll right. Column A stays fixed. Everything to the right scrolls normally.
The freeze line is the visual confirmation that it worked. If you don't see it, check that you're not in Page Layout view — Freeze Panes only works in Normal view, which you can switch to from the same View tab.
Freeze Multiple Columns Without Guessing
The selection rule that decides what stays locked in place
Freezing the first column is a one-click operation, but freezing two or three columns requires a specific selection step that trips up a lot of people. The rule is straightforward once you know it: Excel freezes everything to the left of your selected cell. So if you want Columns A, B, and C to stay frozen, you click on cell D1 — the first cell in the first unfrozen column — and then choose Freeze Panes from the dropdown.
This is where the freeze first column behavior differs from the general Freeze Panes option. "Freeze First Column" ignores your selection and always freezes Column A. "Freeze Panes" (the first option in the dropdown) respects your selection and freezes everything to its left. Selecting the wrong cell before clicking Freeze Panes is the single most common reason people end up with a frozen section they didn't intend.
What this looks like in practice
Take a project tracker with 200 rows and 18 columns. Column A has employee names, Column B has employee IDs, Column C has department, and Columns D through R have monthly metrics. You want all three identifier columns to stay visible while you scroll through the monthly data.
Click cell D1. Then: View → Freeze Panes → Freeze Panes. Columns A, B, and C are now frozen. Scroll right — the names, IDs, and departments stay anchored while months scroll past. The freeze line now sits between Column C and Column D.
If you accidentally froze the wrong columns, don't adjust the selection and try again — that won't change an existing freeze. Go to View → Freeze Panes → Unfreeze Panes first, then reselect and re-apply. Microsoft's documentation on freezing rows and columns confirms this reset behavior and explains why the Freeze Panes option grays out when a freeze is already active.
Unfreeze It Fast When You Pick the Wrong View
How to undo the frozen view without making a mess
Unfreezing is simpler than freezing: View → Freeze Panes → Unfreeze Panes. One click, and the freeze is gone. No cell selection required, no settings to reverse, no data affected. The thin freeze line disappears and the sheet scrolls normally again.
The one thing that catches people off guard: the menu item changes. When no freeze is active, the dropdown shows "Freeze Panes," "Freeze Top Row," and "Freeze First Column." When a freeze is active, "Freeze Panes" is replaced by "Unfreeze Panes." If you're looking for a separate "remove freeze" button, you won't find one — Unfreeze Panes is it.
Why people think Excel is broken when it isn't
A frozen column in a busy workbook can feel disorienting if you didn't set it up yourself. You scroll left and the sheet stops moving before it reaches the beginning. You click on what looks like Column A and it turns out to be Column D. The sheet seems to be misbehaving.
It isn't broken — someone just froze a few columns and the freeze line blends into the grid. Look for the slightly thicker vertical line between columns. If you see it, that's the freeze boundary. Go to View → Freeze Panes and you'll see "Unfreeze Panes" as the first option, which confirms a freeze is active. Click it, and the sheet resets to its normal scrolling behavior. Before-and-after: before unfreezing, scrolling left stops at the freeze boundary; after unfreezing, the sheet scrolls all the way to Column A without interruption.
Protect the Sheet Only When You Actually Need to Stop Edits
Locking cells only starts working after protection is on
Here's the structural point that most Excel guides bury: by default, every cell in a worksheet is marked as "Locked" in its Format Cells settings — but that setting does nothing until you turn on worksheet protection. Locked is a property that only activates when Protect Sheet is enabled. This means that if you've been relying on the "Locked" checkbox in Format Cells to restrict editing, it hasn't been doing anything.
The workflow for actually locking specific cells is:
- Select all cells (Ctrl+A), open Format Cells (Ctrl+1), go to the Protection tab, and uncheck Locked. This makes all cells editable by default.
- Select only the cells you want to protect — formulas, headers, ID columns.
- Open Format Cells again, go to the Protection tab, and check Locked for those cells.
- Go to Review → Protect Sheet, set your permissions, and optionally add a password.
Now only the cells you marked as Locked are restricted. Everything else remains editable. Protect sheet in Excel this way and you get precise control instead of an all-or-nothing lockdown.
Allow Users to Edit Ranges without opening the whole sheet
If you want certain ranges to stay editable for specific people — without turning off protection entirely — use Allow Users to Edit Ranges, found on the Review tab. This lets you define named ranges that bypass the sheet protection for designated users or anyone with the range password.
This is the practical middle ground that most guides skip. You can protect the whole sheet but carve out specific cells that collaborators can still update without needing the full sheet password.
What this looks like in practice
Say you're sharing a staffing spreadsheet with an office assistant. The sheet has employee IDs in Column A, formulas calculating totals in Column F, and a status column in Column E where the assistant needs to update "Active," "On Leave," or "Terminated" each week.
You lock Columns A and F (uncheck Locked everywhere, recheck it on those two columns, then enable Protect Sheet). Then you use Allow Users to Edit Ranges to designate Column E as freely editable. The assistant can update statuses without a password, but can't accidentally overwrite the IDs or break the formulas. The sheet stays functional. The data stays intact. According to Microsoft's guidance on worksheet protection, this combination of locked cells and editable ranges is the intended workflow for shared spreadsheets.
Pick the Permissions That Keep the Sheet Usable
The settings that quietly decide whether coworkers can still do their jobs
When you enable Protect Sheet, Excel shows a list of checkboxes for what locked-out users can still do. Most people either check everything or leave the defaults and move on. The defaults allow selecting locked and unlocked cells — which is fine — but they block formatting, sorting, and filtering, which can make the sheet feel broken to anyone who needs to sort a list or apply a filter to find their data.
The permissions worth thinking through before you click OK:
- Sort — leave this on if coworkers need to reorder rows. Turning it off means they can't sort even the unlocked columns.
- AutoFilter — leave this on if the sheet has filter dropdowns. Without it, the dropdowns stop working.
- Format cells/columns/rows — leave these off unless you want users changing column widths or cell colors, which can break a carefully laid-out sheet.
- Insert/delete rows — leave these off unless the workflow requires adding new records, in which case unlocked insertion rows are a cleaner solution anyway.
Password behavior people misunderstand
The password you set in Protect Sheet is not file-level encryption. It doesn't stop someone from copying the data, opening the file, or viewing the content — it only stops them from making changes through the normal Excel interface. If someone needs the data, they can see it. The password controls editing, not access.
The practical warning: if you forget the sheet protection password, recovering it in modern Excel versions is not straightforward. There's no "forgot password" option. Keep the password somewhere you'll find it, or use a simple memorable one if the goal is just preventing accidental edits rather than genuine security. For real file security, use Excel's file-level encryption under File → Info → Protect Workbook → Encrypt with Password — that's a different feature entirely.
Use Freeze Panes for Readability and Protect Sheet for Control
The rule of thumb that saves people from doing the wrong thing
The decision rule is simple: if the problem is that you can't see your labels while you scroll, use Freeze Panes. If the problem is that someone might accidentally overwrite your formulas or headers, use Protect Sheet. These are different problems. They have different solutions. You can use both on the same sheet — and often should — but applying them in the wrong order or using one when you need the other wastes time and creates confusion.
Freeze panes in Excel is always the first step when you're setting up a sheet that others will use. It makes the sheet readable without touching any data or permissions. Protection comes second, after the layout is right, and only when the sheet is actually being shared with people who might edit it.
What this looks like in practice
A clean office workflow looks like this: you build the employee roster, freeze Columns A and B so names and IDs stay visible, then protect the sheet with formulas locked and the status column left editable. Anyone who opens the file can scroll through 300 rows without losing track of who they're looking at, and the formulas in the summary tab stay intact no matter how many people update statuses.
For an interview, the explanation is: "Freeze Panes keeps your headers and labels visible while you scroll — it's a display setting. Protect Sheet stops people from editing cells you've marked as locked — it's a permissions setting. You'd typically do both on a shared spreadsheet, freeze first so it's readable, then protect so it's safe." That answer demonstrates practical Excel knowledge without overcomplicating it, and it shows you understand the difference between a UI feature and a security feature — which is more than most entry-level candidates can articulate.
How Verve AI Can Help You Prepare for Your Interview With Lock Columns in Excel
Excel questions in interviews aren't usually about whether you know the exact menu path — they're about whether you can explain a feature clearly enough that a manager trusts you to use it on real work. The gap between knowing how to freeze columns and being able to explain it confidently under interview pressure is where most candidates lose points.
Verve AI Interview Copilot is built for exactly that gap. It listens in real-time to the conversation and responds to what you actually said — not a canned script — so when an interviewer follows up with "what's the difference between that and protecting the sheet?" you're not scrambling for a memorized answer. Verve AI Interview Copilot can run mock sessions on practical Excel scenarios, push follow-up questions that mirror what a real hiring manager would ask, and give you feedback on whether your explanation was clear or just technically correct. The difference matters. Verve AI Interview Copilot stays invisible while it does all of this, which means you practice the way you'll actually perform — live, under pressure, without a script in front of you.
---
FAQ
Q: How do I lock a column in Excel so it stays visible while I scroll?
Use Freeze Panes, not sheet protection. Go to View → Freeze Panes → Freeze First Column to keep Column A visible while you scroll right. For multiple columns, click the first cell in the column you don't want frozen (e.g., D1 to freeze columns A–C), then choose View → Freeze Panes → Freeze Panes.
Q: What is the difference between freezing columns and protecting or locking cells?
Freezing is a display setting — it keeps columns visible on screen while you scroll without touching the data or permissions. Protecting locks cells against editing and requires worksheet protection to be turned on before the lock takes effect. They solve different problems and live in different tabs: View for Freeze Panes, Review for Protect Sheet.
Q: When should I use Freeze Panes instead of worksheet protection?
Use Freeze Panes whenever the problem is that labels or identifiers disappear off-screen as you scroll. Use Protect Sheet when you need to stop people from accidentally editing formulas, headers, or reference data. If you need both — a readable layout and edit restrictions — freeze first, then protect.
Q: How do I freeze the first column or multiple columns in a long spreadsheet?
For the first column only: View → Freeze Panes → Freeze First Column. For multiple columns: click the cell in the first column you want to remain scrollable (e.g., click D1 to freeze A, B, and C), then View → Freeze Panes → Freeze Panes. The freeze line appears between the last frozen column and the first scrollable one.
Q: How do I unfreeze columns if I choose the wrong setting?
Go to View → Freeze Panes → Unfreeze Panes. This single click removes all active freezes. The menu item only appears as "Unfreeze Panes" when a freeze is currently active — if you see "Freeze Panes" as the first option, no freeze is set.
Q: What's a practical example of using locked columns in office spreadsheets?
A shared employee roster where Column A (names) and Column B (IDs) are frozen so they stay visible while coworkers scroll through monthly data columns. The formula cells and ID columns are locked via sheet protection, but the status column is left editable through Allow Users to Edit Ranges so the assistant can update records without a password.
Q: How can I explain this Excel skill clearly in a job interview or at work?
Keep it structural: "Freeze Panes keeps headers and labels visible while you scroll — it's a display feature. Protect Sheet stops people from editing cells you've marked as locked — it's a permissions feature. On a shared spreadsheet, I'd freeze the identifier columns first so the sheet is readable, then protect the formula cells so they can't be accidentally overwritten." This answer is specific, practical, and shows you understand the purpose of each feature, not just the menu path.
---
The original confusion is worth resolving one more time before you close this tab: if you wanted columns to stay visible while scrolling, Freeze Panes was always the answer, and it takes about three seconds to apply. If you also need to stop accidental edits, Protect Sheet handles that separately, after the layout is right. The two features complement each other — they just don't substitute for each other. Open a real spreadsheet, freeze the first column, scroll right to confirm it works, then decide whether the sheet actually needs protection before you add it. That hands-on sequence will make the distinction stick faster than any explanation will.
Reese Nakamura
Interview Guidance
