Google Sheets - Protect or Totally Hide Data Using IMPORTRANGE
It is easy to protect certain cells or worksheets from editing. However, in this tutorial, we will review how to totally hide confidential data while allowing users to see a summarized version without the sensitive data. This prevents the data from being modified but also prevents it from being viewed.
Link to the example sheet with the IMPORTRANGE formula: https://bit.ly/import-range
Written version of this video: https://sheetshelp.com/hide-data/
More information on IMPORTRANGE: https://sheetshelp.com/importrange/
Learn more from Prolific Oaktree:
🌳 Next Video - Spreadsheets 3.0 - • Beyond Sheets and Excel *|* First Imp...
🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/google-tutorials
Timestamps:
0:00 General Setup
1:37 Setup for this spreadsheet
3:34 IMPORTRANGE function
5:52 Security consideration
7:14 Next: Pivot Table Playlist
#googlesheets #IMPORTRANGE