protection

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection

Protection

resolvedResolved · Low Priority · Version 2003

Mary has attended:
Excel Intermediate course
Project Intermediate course

Protection

How do you password protect a workbook?

RE: Protection

Hi Mary,

Thank you for your question.

In order to protect a workbook, please follow these instructions:

1. File - Save AS.
2. Name the file and choose the location to save it in.
3. Then click on the Tools menu.
4. Select General options.
5. You can now enter two passwords if you want, one to open the workbook ad the second to modify it.
6. Then save the document.

To remove a password, once the file is opened, follow instructions 1,2,3,4 and highlight the stars in the password field and delete them so the boxes are blank. Then save the document.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips


Server loaded in 0.08 secs.