Forum Discussion
Protecting only 1 column
How do I protect only 1 column in a spreadsheet?
- 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.