Microsoft Office Tutorials and References
In Depth Information
If you share your worksheets with others, you can
protect them so others can view and print them, but
cannot make changes to them. Even if you do not
share your worksheets, you may want to lock certain
areas so you do not inadvertently make changes.
Locking your worksheet enables users to make certain
types of changes while disallowing others. For
example, you can allow users to make changes to
formats; insert or delete columns, rows, or hyperlinks;
sort; filter; use PivotTables; and/or edit objects or
By default, when you lock a worksheet, Excel locks
every cell in the worksheet, and the formulas are
visible to anyone who uses the worksheet. You can
specify the cells that remain unlocked, and you can
To protect your worksheet, enter a password
in the Protect Sheet dialog box. Keep a list of
your worksheet passwords in a safe place because a
worksheet password cannot be recovered. If you lose
or forget your password, you can no longer access
the locked areas of your worksheet.
Click and drag to select the cells
you want to remain unlocked
or whose formulas you want
Click the Home tab.
Click Format in the Cells group.
A menu appears.
Click Format Cells.
l The Format Cells dialog box
Click the Protection tab.
l By default, Locked is selected.
Selecting Locked enables you
to lock the selected cells, and
deselecting Locked enables
you to leave the selected cells
l By default, Hidden is deselected;
select it if you want to hide your