Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2023-10-17 14:45:02 | ![]() 28,877 Views |
Password protect and completely hide worksheets in Excel in order to protect sensitive data, like source data, pivot table data, etc.
This tip helps a lot when you send big workbooks to coworkers and only want them to focus on specific worksheets.
This requires no coding, no vba or macros, and it allows you to keep important worksheets and data safe so that they can’t be easily changed and messed up while you keep other front-facing worksheets visible and usable.
Resources:
Download the File: https://www.teachexcel.com/excel-tutorial/2674/hide-worksheets-with-passwords-in-excel-no-code-required?src=yt
Protect Excel Data (Microsoft): https://www.microsoft.com/en-us/microsoft-365-life-hacks/privacy-and-safety/how-to-password-protect-excel-workbooks
TeachExcel Online Courses: https://www.teachexcel.com/premium-courses/?src=yt_description_Og0ST8fD8f0
00:00 How it Works
00:47 Super Hide a Worksheet from View
02:04 Password Protect Hidden Worksheets
03:30 Show a Password Protected Hidden Worksheet
#msexcel #tutorial #exceltips #freetutorial #excel
Please take the opportunity to connect and share this video with your friends and family if you find it useful.