Page 14 of 32PREVNEXT

Help secure and protect data in Excel

The Tools menu and the Protect Workbook dialog box

Callout 1 Select the Structure check box to keep worksheets from being moved or renamed.
Callout 2 Select the Windows check box to keep windows the same size and position.
Callout 3 Type a password in the Password box.

If you have a workbook that you've carefully organized — worksheets in a certain order, worksheet tabs named just so — you can protect that structure from being tampered with by using the Protect Workbook command.

On the Tools menu, point to Protection, and then click Protect Workbook. You can select the options to protect your workbook Structure and Windows.

When you protect the structure, worksheets can't be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be inserted.

When you protect windows, they'll appear the same size and position as you left them each time the workbook is opened.

Type a password for the workbook in the Password box. This does not encrypt the workbook contents, and it is optional. This password is not used to open the workbook; it's only used to unprotect the workbook if you decide to change the structure. If you don't supply a password, however, anyone will be able to unprotect the workbook.

Page 14 of 32PREVNEXT