Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting spreadsheets
Resolved · Low Priority · Version 2007
Hi Tony,
Welcome to the forum, and thank you for your post;
In order for a cell to be protected - The worksheet must be protected and the "Locked" checkbox on the (Format > Cells)(Protection tab) must also be checked. (This is the default).(Format > Cells)(Protection tab)
If you only want to protect a few cells - first remove the locked property from all the cells. Select (Ctrl + "A") and clear the locked check box. This will mean that even if the worksheet is protected the cells will not be. Select the individual cells that contain formulas you want to protect and change the property back to Locked.
If you want to protect a few formulas without protecting the whole sheet select the cells and choose (Data>Validation), Select custom in the first window and type (="") in the second window.
I hope that has helped, regards Pete
|
Excel tip:Sum Up All the Values in A ColumnIf you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be: |
We'll call during UK business hours
Server loaded in 0.07 secs.