microsoft-excel-courses - excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Excel

microsoft-excel-courses - Excel

resolvedResolved · Low Priority · Version Standard

Sarah has attended:
Excel Intermediate course

Excel

How do you password protect a worksheet?

RE: Excel

Hi Sarah, Thank you for the post, In answer to your question you can password protect the worksheet by selecting the option Tools, Protection, Protect Worksheet, you will enter a password, which will require to be confirmed. Note this does not stop users from viewing the data, it only stops them from entering or editing any of the data. If you wish to only allow certain people to view the worksheet you will have to protect the entire workbook,
You can password protect the entire workbook by following these steps.
Choose the option Save As, in the Save As dialog box, give the file a name, and select the type of file (ie workbook or template) At the top right of the dialog box there is an option called Tools with a drop down, click the drop down and choose the option General Options, you will open a dialog box which will allow you to set two passwords one to open the file and the second to modify. You can choose one or both, note you will have to verify the password you enter. From there, you will then save the file and the next time it is opened it will prompt for a password. Hope that helps, best regards Pete.


 

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




View all Excel hints and tips


Server loaded in 0.09 secs.