Protect your spreadsheets

摘要

There are all sorts of ways you can restrict access to your Excel files, worksheets or even ranges and cells. You may have reasons ranging from wishing to conceal confidential information from others to simply preventing yourself from inadvertently deleting a complicated formula.rnA quick way to hide data in a cell is to format the displayed value in the cell in the same colour as the background. The most drastic step is to not allow anyone to open a workbook at all without a password.