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

protecting worksheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting worksheets

Protecting worksheets

ResolvedVersion 2007

Louise has attended:
Excel Introduction course
Excel Intermediate course

Protecting worksheets

How do you protect your worksheet?

RE: Protecting worksheets

2 ways for this:
The 1st is to go to the Review Tab and click on Protect Sheet.
or
On the Cells Group of the Home tab, choose format and Protect Sheet.
See your manual for more details - and it's definitely worth doing!

Clare

Sun 20 Feb 2011: Automatically marked as resolved.

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

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.