To protect columns in Excel for Microsoft 365 on Windows, unlock the cells people may edit, leave the cells in the columns you want to protect locked, then choose Review > Protect Sheet. Excel’s cells are marked as locked by default, but that setting only takes effect after you protect the worksheet.
What protecting a column actually does
Excel does not apply worksheet protection to a column as a separate security boundary. Instead, each cell has a Locked property, and protecting the worksheet makes that property matter. A column is effectively protected when its cells are locked and the sheet is protected. You can also lock individual cells or ranges rather than whole columns.
With protection on, users cannot change locked cells through ordinary worksheet editing. They can still view their contents, and depending on the options you allow, select cells, use filters, format cells, or perform other permitted actions. This is useful for keeping formulas, labels, or reference values from being accidentally overwritten while leaving entry areas available.
A common example is a project tracker with task names in column A, status choices in column B, and calculated dates or formulas in columns C and D. You might leave A and B unlocked so colleagues can update tasks, while protecting C and D. Worksheet protection does not hide those formulas or make the workbook secure against someone determined to access its contents.
Prepare the worksheet before protecting columns
Decide first which cells should remain editable. If you protect a sheet without changing the default Locked setting, Excel can prevent editing throughout the sheet, not just in the columns you had in mind. For a sheet where most cells should be editable and only a few columns should be protected, start by unlocking the whole sheet.
- Select the worksheet’s entire grid by clicking the Select All triangle above row 1 and to the left of column A.
- Press Ctrl+1 to open Format Cells. On a Mac, use Command+1.
- Open the Protection tab, clear the Locked checkbox, and select OK. The cells are now marked unlocked, but users can still edit them because sheet protection is not on yet.
- Select the column or columns to protect by clicking their lettered headers. To choose separate columns on Windows, hold Ctrl as you click each header. On a Mac, hold Command.
- Press Ctrl+1, or Command+1 on a Mac, open Protection, select Locked, and select OK.
- Choose Review > Protect Sheet. In the dialog, keep Protect worksheet and contents of locked cells selected. Set a password if appropriate, choose the actions users may perform, and confirm.
After protection is enabled, try editing a locked cell and an unlocked one. Excel should block changes to the locked cell while allowing changes to the unlocked cell. This quick check catches selection or setup mistakes before you share the workbook.
Protect columns when most of the sheet should be locked
If the worksheet is already arranged so that only a few cells should be editable, you can use the default Locked setting to your advantage. Leave the cells you want protected alone, unlock only the input cells, and then protect the sheet. For example, if column F contains formulas and column G is for employee comments, unlock G while leaving F locked.
To unlock just the entry column, select its header, press Ctrl+1 on Windows or Command+1 on Mac, clear Locked on the Protection tab, and select OK. Then choose Review > Protect Sheet. If only particular rows in that column are input areas, select those cells instead of the entire column. Selecting a smaller range avoids accidentally allowing edits in unused or calculated cells.
Remember that the Locked checkbox is a property of cells, not a visible indicator that protection is active. You can inspect or change it later through Format Cells > Protection. The Home tab also has a Lock Cell command under Home > Format; it toggles the selected cells’ Locked setting. Changing that setting does not itself turn worksheet protection on or off.
Choose what users can still do
The Protect Sheet dialog lets you control more than whether users can edit locked cells. The available checkboxes determine which actions remain possible while the sheet is protected. Choose only the actions the worksheet needs; allowing an action does not unlock every cell or grant unrestricted editing.
- Select locked cells: Allows users to click or navigate to protected cells. Clear it if users should move only among editable cells, but note that this does not hide protected content.
- Select unlocked cells: Allows users to reach the cells intended for data entry. Keep it selected if the sheet has editable areas.
- Format cells, columns, or rows: Allows the corresponding formatting changes. These options are separate from permission to change locked cell values.
- Insert or delete rows and columns: Allows those structural actions when selected. Consider whether changing the layout could disrupt formulas, references, or the protected design.
- Sort and use AutoFilter: These options are available in the dialog. Set up the filter before protecting the sheet, and test the workflow with the actual protected range; sorting can be restricted when the range contains locked cells.
The right settings depend on the job. A data-entry form may allow selecting unlocked cells and using a drop-down list, but not formatting or inserting columns. A report may permit selecting protected cells for copying while blocking edits. Try the intended tasks with a non-owner account or a copy of the file before relying on the settings.
Passwords, protection, and confidentiality
A password in the Protect Sheet dialog helps prevent casual changes to the protection settings. Anyone who needs to unprotect the sheet will need that password. Store it somewhere appropriate and share it only with people responsible for maintaining the workbook; if it is lost, access to the protection settings may be difficult to restore.
Worksheet protection is primarily an editing control, not a way to keep confidential information secret. It does not encrypt the workbook, and it does not stop authorized viewers from reading visible values or copying data. Do not place sensitive information in a sheet on the assumption that locking its columns conceals them.
If the goal is to require a password to open the workbook, that is a different setting from Protect Sheet. In Excel for Windows, file encryption is available through File > Info > Protect Workbook > Encrypt with Password. Keep in mind that file encryption and worksheet editing protection solve different problems: one controls opening the file, while the other limits worksheet actions.
Common problems and how to fix them
- Users can still edit the supposedly protected column. Confirm that the cells are marked Locked and that Review > Protect Sheet is active. A locked setting alone has no effect on an unprotected sheet.
- Users cannot edit the input cells. Select the intended input range, clear Locked in Format Cells > Protection, and protect the sheet again. If the sheet was already protected, choose Review > Unprotect Sheet first; enter the password if prompted.
- Everything is blocked. This usually happens when the sheet was protected while all cells retained Excel’s default Locked setting. Unprotect it, unlock the areas intended for editing, and protect it again.
- People can select a locked cell but cannot change it. That is expected if Select locked cells is enabled. Clearing that option prevents selection, not viewing, and is not a substitute for hiding or securing data.
- A filter or sort does not work as expected. Check the related permissions in Protect Sheet and verify the filter was created before protection. Worksheet protection can impose limits on sorting ranges that include locked cells, so test the exact range and process.
When changing a protected workbook, avoid trying to fix the issue by repeatedly toggling Locked without checking the sheet’s protection state. First unprotect the sheet, adjust the cell settings, and then protect it again. This makes it easier to tell whether a problem comes from a cell’s Locked property or from the actions permitted in the protection dialog.
Excel for the web and Mac differences
In Excel for the web, worksheet protection and the available controls can differ from the Windows desktop dialog. Use the Review tab and its sheet-protection controls if they are available in your workbook, and check the options shown in that version. If you need a specific permission or cannot change a protection setting in the browser, open the workbook in desktop Excel and configure it there.
Excel for Mac has the same basic approach: set cells as locked or unlocked, then protect the worksheet. The main shortcut difference in the steps above is Command+1 for Format Cells rather than Ctrl+1. Ribbon layouts and dialog details can vary slightly by platform and update, so use the Protection tab in Format Cells and the Protect Sheet command on Review as the key controls.
When another approach is a better fit
For ordinary collaboration, protecting selected formula columns while unlocking input cells is often enough to prevent accidental edits. If users need controlled data entry, consider using data validation, such as a drop-down list, in the unlocked cells. Validation helps guide what people enter; it does not replace sheet protection or guarantee that every pasted value will meet your rules.
If the requirement is to limit who can open or edit a file, use the appropriate file-level password or sharing permissions instead of relying only on sheet protection. If several people need to edit different parts of a workbook at the same time, consider whether a shared workbook workflow or a dedicated data-entry system better fits the task. The key distinction is whether you are preventing mistakes in a worksheet or controlling access to information and files.
Frequently Asked Questions
Can I protect only one column in Excel?
Yes. Mark the cells in that column as Locked, then protect the worksheet. If other columns should remain editable, unlock those cells before protecting the sheet. Protection applies through cell settings rather than a separate column-level security command.
How do I protect a column without locking the whole sheet?
Unlock the cells that users should be able to edit, leave the target column locked, and then select Review > Protect Sheet. The sheet must be protected for locked cells to be blocked from editing, but unlocked cells remain editable.
Can people see or copy a protected column?
Yes. Sheet protection restricts worksheet actions; it does not hide the values in locked cells or provide strong confidentiality. If the contents must be private, do not share them in a workbook that recipients can open.
How do I remove protection from a column?
Choose Review > Unprotect Sheet and enter the password if Excel asks for it. Then select the cells, open Format Cells > Protection, and clear Locked. If the sheet remains protected, changing the Locked property may not be possible.
Can I protect a column without a password?
Yes. You can protect a worksheet without setting a password, though users may then be able to remove protection without entering one. A password is optional for the sheet-protection feature; it does not turn that feature into file encryption.
Related
- No Remove Duplicates Option in Excel? Find It
- No Hyperlink in Excel? Remove or Prevent Links
- Excel File Corrupted? How to Check, Repair, and Recover
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Run a PowerPoint Slideshow in a Continuous LoopTo run a PowerPoint slideshow continuously in Microsoft 365 for Windows, open the presentation and select Slide Show…
- Excel Format Cells Shortcut: Open the Dialog in SecondsIn Excel for Windows, select a cell or range and press Ctrl+1 to open the Format Cells dialog…
- Free Debt Snowball Payoff Spreadsheet: Build One in ExcelYes—free debt snowball payoff spreadsheets are available, and you can also build a simple one in an Excel…
- Excel Dependent Drop-Down Lists in Microsoft 365Yes. In Excel for Microsoft 365, you can make a dependent drop-down list by using Data Validation with…
- How to Find Hidden Tabs in ExcelTo find a hidden worksheet in Excel for Microsoft 365 on Windows, right-click any visible sheet tab, choose…
- Creating a Calendar in Google Sheets: Steps and TipsTo create a calendar in Google Sheets, open a blank spreadsheet, set up weekday headings and a date…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.