Hide formulas in Excel

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

Lesson tags: vlookup
Back to: POPIA and GDPR Compliance- Built in Excel Tools that will help > Control access to information in Excel Spreadsheets