Control access to information in Excel Spreadsheets

Hide formulas in Excel

This is a preview lesson
Register or sign in to take this lesson.
Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

When you protect a sheet you typically stop users from changing your formulas. However, you can also control whether a user can see a formula on a cell. If you want the formula to be hidden you need to follow a slightly different process.

To follow along go to 19.7