protecting workbooks

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

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

Protecting workbooks

resolvedResolved · Low Priority · Version Standard

Lesley has attended:
Excel Intermediate course

Protecting workbooks

How do you protect workbooks

RE: protecting workbooks

Hi Lesley, Thank you for your post, in answer to your question, there are two options open to you; the first is to protect your workbook against changes to the Structure which you can access from the Menu option Tool>Protection and choosing the Protect Workbook option you will be given two tick boxes one for Structure and one for Windows, you can apply a password at this point.
The second is to apply a password protection to open the Workbook, this can be accessed from the File>Save As option, Click the little drop down arrow next to the Tools button and choose the option General Options, in the dialog box that appears you can set a password to open and/or modify the Workbook. This option is also available under the
Menu option Tools>Options and under the tab for Security you can set the same password options. I hope that answers your question, best regards Pete.

RE: protecting workbooks

Many thanks.


 

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.