password 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 » Password protection

Password protection

resolvedResolved · Low Priority · Version 2003

Rupinder has attended:
Excel Advanced course

Password protection

How can i password protect a workbook?

RE: Password protection

Hi Rupinder,

Thank you for your question.

Go to File and Save As, find the Tools menu and choose General options and type a password to open and modify if you wish. You will then be asked to confirm the password.

Then save the file to the appropriate location.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.