Making protected Excel Spreadsheets easier to use

Trick: Allow user to only see their information 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.

This is a trick to be able to send out one spreadsheet which contains everyone’s information, but set it up so that a single person can only see their data and not the other users.

To follow along go to 19.8