Excel Digest

  Excel help for the rest of us

Archive for the 'Security and Protection' Category

12 Jun

How to remove personal information from a workbook

When you save a workbook (or any other Microsoft Office document), some of your personal information like Author, Manager, Company and Last saved by are saved as File properties. If you want to share your workbook with others, then you may want to remove this information before you distribute it.
There are two things you can [...]

07 May

How to protect or unprotect cells in a worksheet

In a previous post we talked about how to protect worksheet elements. When you protect a worksheet, by default all its cells will be locked.
If you want to protect or unprotect some cells selectively then do the following:

Select the cells you want to protect / unprotect.
In the main menu click Format.
Click Cells. The Format Cells [...]

03 May

How to protect Worksheet elements

To prevent unauthorized users from performing certain worksheet tasks, like formatting cells, deleting rows or inserting rows, follow these steps:

Switch to the worksheet you want to protect.

On the Tools menu, point to Protection, and then click Protect Sheet.
Type a password for the sheet. Then reconfirm [...]

28 Apr

How to protect a workbook with a password

To allow only authorized users to view or modify your Excel workbook, you can secure your entire workbook file with a password. Follow the steps below to achieve this goal:

On the File menu, click Save As.
Click Tools.
On the Tools menu, click General Options.

If you want [...]

© 2008 Excel Digest | Entries (RSS) and Comments (RSS)

GPS Reviews and news from GPS Gazettewordpress logo