B borkot01 Jan 6, 2004 #1 How do you protect a range of cells from being changed without protecting the entire worksheet? Thanks
How do you protect a range of cells from being changed without protecting the entire worksheet? Thanks
C Candice Mesk Jan 6, 2004 #2 All cells are automatically marked as protected by Excel (only effective once you protect the sheet). Press Ctrl+A to select the entire sheet. Format Cells >Protection tab. Uncheck the Locked option. Click to expand... Now select the cells you want to protect, format those ones only as Locked. Then, Tools > Protection and do your thing.
All cells are automatically marked as protected by Excel (only effective once you protect the sheet). Press Ctrl+A to select the entire sheet. Format Cells >Protection tab. Uncheck the Locked option. Click to expand... Now select the cells you want to protect, format those ones only as Locked. Then, Tools > Protection and do your thing.
G Gord Dibben Jan 6, 2004 #3 You can unlock some cells but you must still have protection set on the sheet. By default all cells on a sheet are locked when you protect the sheet. Before you protect it you can select cells you want unlocked and Format>Cells>Protection. Clear the "locked" checkbox. Now Tools>Protection>Protect Sheet. With XL2002 there are a whack of options you can set for a protected sheet. Gord Dibben Excel MVP
You can unlock some cells but you must still have protection set on the sheet. By default all cells on a sheet are locked when you protect the sheet. Before you protect it you can select cells you want unlocked and Format>Cells>Protection. Clear the "locked" checkbox. Now Tools>Protection>Protect Sheet. With XL2002 there are a whack of options you can set for a protected sheet. Gord Dibben Excel MVP
