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
Watch video Google Sheets - Protect or Totally Hide Data Using IMPORTRANGE online, duration hours minute second in high quality that is uploaded to the channel Prolific Oaktree 13 May 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 30,283 times and liked it 197 visitors.
