Wednesday, October 19, 2011

Microsoft Excel: How to Protect My Formulas in Excel Sheets


1. Open Excel and type a formula in cell A1. Right click on the cell and select 'Format Cells.' Select the 'Protection' tab. Check the option for 'Hidden.' Click 'OK.' The hidden option lets you hide the content of the cells but it requires that the worksheet be protected for this to be activated.
2. Select the 'Review' tab and locate the Changes group. Within the Changes group, select 'Protect Sheet.' Make sure the 'Protect Worksheet and contents of lock cells' option is checked. Type a password in the 'Password to Unprotect Sheet' field. Confirm the password at the 'Confirm Password' prompt. Write this password in a secure location so you don't forget it. Click 'OK' to confirm the password protection.
3. Verify the password protection by going to cell A1. Look at the formula bar and notice it is blank. If you send this workbook to other users, they will get the same result. Your formula is protected and not visible unless they have the password. Do this for each cell or range where you want to protect your formulas.

Blogger news