Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Protecting formula in cells
0 views
Skip to first unread message
BB
Apr 21, 2004, 8:29:43 PM4/21/04
to
I am not going to be using this spreadsheet myself, so how
would I go about protecting a cell with a formula in it?.
I don't want anyone typing over the formula, because the
people who are going to use this spreadsheet don't know
anything about how to repair the formulas. Please help.
would I go about protecting a cell with a formula in it?.
I don't want anyone typing over the formula, because the
people who are going to use this spreadsheet don't know
anything about how to repair the formulas. Please help.
Gord Dibben
Apr 21, 2004, 8:52:45 PM4/21/04
to
BB
By default all cells on a worksheet are "locked for editing" when
Tools>Protection>Protect Sheet is enabled.
To "lock" just some cells......
CRTL + A to select all cells.
Format>Cells>Protection. Uncheck "locked".
Select your specific cells on the worksheet and Format>Cells>Protection.
Checkmark "locked".
Now Protect the Worksheet.
Gord Dibben Excel MVP
On Wed, 21 Apr 2004 17:29:43 -0700, "BB" <anon...@discussions.microsoft.com>
wrote:
0 new messages