Microsoft Support Number OR Call Toll-Free @ 1-844-478-2887

Thursday, May 21, 2009

How to Use Security and protection in MS Excel

Microsoft Office Excel provides several layers of security and protection that allows you to control who can access and change your Excel data. To Microsoft help protect the data in a workbook, you can do the following:

For optimal security, you should protect your entire workbook file with a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), which allows only authorized users to view or modify your data.

For additional protection of specific data, you can also protect certain worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) or workbook elements, with or without a password. Protecting worksheet or workbook elements may help prevent users from accidentally or deliberately changing, moving, or deleting important data.

You can protect Using Two Types
Using passwords to help secure an entire workbook
Protecting specific worksheet or workbook elements

No comments: