Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

using templates and auditing

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using templates and auditing

Using templates and auditing

ResolvedVersion 2003

Christina has attended:
Excel Intermediate course

Using templates and auditing

How do I protect workseets and data

RE: Worksheet and workbook protection!!

Dear Christina

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

Normally when you protect a worksheet all the cells get protected and therefore no cells are available for editing and formatting!!

To protect only certain cells in the worksheets please follow these steps:

1. Select all the cells that you want to be edited when the worksheet is protected.
2. Choose Format > Cells

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.