Protecting Excel Data
The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified. Excel has several protectionrelated features.
Worksheets often contain numerical information that is confidential in nature, such as financial or payroll data. In today's world of electronic snooping, it's up to you to protect your work against prying eyes. Excel provides a large number of security tools such as password protection, hiding sensitive worksheet areas, or locking data against unwanted changes.
This tutorial is about the security concerns surrounding Excel workbooks. We will show you many distinctive protection methods.
In this tutorial:
- Quickly Hide an Open Workbook
- Make a File Read-Only
- Mark a Workbook as Final
- Inspecting a Workbook
- Hide and Unhide Columns and Rows
- Excel Unlock Cells
- Protect Worksheets
- Excel Restrict User Data Entry
- Excel Assign a File Password
- Excel Hide Cell Formulas
- Protecting a workbook's structure
- Using a digital signature in Excel
- Signing a Workbook
