Forum Discussion

modifiedog's avatar
modifiedog
Copper Contributor
May 09, 2025

Protecting only 1 column

How do I protect only 1 column in a spreadsheet?

excel

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 09, 2025
    • Press Ctrl+A (if necessary repeatedly) to select the entire sheet.
    • Press Ctrl+1 to activate the Format Cells dialog.
    • Activate the Protection tab.
    • Clear the Locked check box.
    • Click OK.
    • Now select the column that you want to protect.
    • Press Ctrl+1 to activate the Format Cells dialog.
    • Activate the Protection tab.
    • Select the Locked check box.
    • Click OK.
    • Activate the Review tab of the ribbon.
    • Click Protect Sheet.
    • Use the check boxes to specify what users will be able to do.
    • If you want the sheet to be password-protected, enter a password. Don't forget it!
    • Click OK.
    • If you entered a password, you'll have to enter it again as confirmation.
    • Save the workbook.

Resources