Super Quick Way To Unprotect Multiple Excel Worksheets

𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨𝐠 𝐟𝐨𝐫 𝐥𝐨𝐭𝐬 𝐨𝐟 #𝐞𝐱𝐜𝐞𝐥𝐭𝐢𝐩𝐬.
𝐉𝐨𝐢𝐧 𝐭𝐡𝐨𝐮𝐬𝐚𝐧𝐝𝐬 𝐨𝐟 𝐨𝐭𝐡𝐞𝐫 𝐄𝐱𝐜𝐞𝐥 𝐮𝐬𝐞𝐫𝐬 𝐰𝐡𝐨 𝐡𝐚𝐯𝐞 𝐚𝐥𝐫𝐞𝐚𝐝𝐲 𝐣𝐨𝐢𝐧𝐞𝐝 𝐭𝐡𝐞 𝐄𝐱𝐜𝐞𝐥 𝐀𝐭 𝐄𝐱𝐜𝐞𝐥 𝐌𝐨𝐧𝐭𝐡𝐥𝐲 𝐍𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫. 𝟑 𝐅𝐑𝐄𝐄 𝐄𝐱𝐜𝐞𝐥 𝐓𝐢𝐩𝐬 𝐞𝐯𝐞𝐫𝐲 𝐦𝐨𝐧𝐭𝐡. 𝐏𝐥𝐮𝐬 𝐅𝐑𝐄𝐄 𝟑𝟎 𝐓𝐢𝐩𝐬 𝐄𝐁𝐨𝐨𝐤.

𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦/𝐧𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫-𝐬𝐢𝐠𝐧-𝐮𝐩/
𝐁𝐞 𝐒𝐨𝐜𝐢𝐚𝐥 & 𝐋𝐞𝐭❜𝐬 𝐂𝐨𝐧𝐧𝐞𝐜𝐭
👍𝐖𝐞𝐛𝐬𝐢𝐭𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦
👍𝐓𝐰𝐢𝐭𝐭𝐞𝐫 𝐡𝐭𝐭𝐩𝐬://𝐭𝐰𝐢𝐭𝐭𝐞𝐫.𝐜𝐨𝐦/𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱

My Recommended Excel Courses

In this video I will show you how to unprotect multiple Excel worksheets really quickly. Have you created an Excel workbook with multiple Excel worksheets that are protected and then at a later date have to unprotect each worksheet individually?. Maybe you need to update your formulas?.
For example, I have a number of reports that have 15+ worksheets. All of those worksheets are protected.
Do I need to manually go into each of the worksheets one by one?. That would take a bit of time wouldn’t it?. So many questions!.

Using The INFO Option To Unprotect Excel Worksheets.
Well, if we use the INFO option we can do it all with a couple of quick mouse clicks.

Excel 2016
• Select File | Info
• At the top of the page, you will see all of the protected worksheets.
• Just click unprotect on the ones you want to remove protection, yes it is THAT quick.

[wayneedmondson]

Hi Barbara. Nice one! Thanks for sharing :)) Thumbs up!!

[robmonroe]

Beyond useless. I have 50 sheets and need to unprotect all of them. I would rather not type my password 50 times.

[eslamfahmy]

If I need to give allow at some area. only hide a formula

[Idle_villager]

This does not at all address the issue - you still have to manually unprotect each worksheet one-by-one....

[infinger]

Change the title.. wasted my time. Thanks for the help in other areas, tho..