Prolific Oaktree's video: 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: 🎓Master the Fundamentals of Google Sheets - http://bit.ly/PO-Basics 🌳 Next Video - Spreadsheets 3.0 - https://youtu.be/UmrbX3b7uNg 🌳 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