How to Protect and Hide Excel Formulas From Being Changed in Shared Worksheets
38,579
Published 2022-11-02
Learn Excel the FAST way, find out how here 👉 www.excel-university.com/yt
Check out 7 Excel Time Hacks Everyone Should Know here • 7 Excel Time Hacks Everyone Should Kn...
Subscribe here 👉 youtube.com/c/ExcelUniver... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here youtube.com/playlist?list...
Watch VLOOKUP vs SUMIFS Playlist here youtube.com/playlist?list...
Watch Dynamic Arrays playlist here youtube.com/playlist?list...
Watch Treasure Maps playlist here youtube.com/playlist?list...
Watch Slow to Fast playlist here youtube.com/playlist?list..
All Comments (15)
-
this really helped me to protect my warehouse formulas
-
Thank you for explaining the default settings and how to enable restrictions such as Hidden.
-
As always, great info!
-
Great tips Jeff! Thanks!!
-
This was the best explanation after 10 videos, subscribed, would be good to know more about Excel, for instance I hadn't heard of the PMT function before! Cheers
-
Thanks sir ❤❤❤
-
Thanks, Heisenberg! 😁
-
Awesome explanation👍🏾
-
can you do a video on how you can put formulas in but the cell looks empty
-
Thanks for all you do. I have a question. I know there is a way to make an Excel so that if someone sends it to another person, it will stop working. I have Excels that I sell & customers have to enter in current data. I understand how to unlock certain cells [so customers can enter current info] & lock others [so customers cannot edit or copy formulas], then protect the sheet. I also add copyright info in locked cells so that no one can resell it. But there is nothing stopping them from looking up a YouTube video on how to remove that protectection. It's actually pretty easy. But I know others in my same niche who create Excels & somehow they protect that Excel from being emailed to anyone else. This is exactly what I need so that no one steals my work & resells it. It's been a huge problem. I come out with a new Excel product and after a month of sales, everyone has it. The customers in my community are very close & share information, so after one person buys it, they just send it to all of their friends. I know there is a way to do this, but all the people selling Excels in this niche are very close mouthed and DON'T share knowledge.
-
Why can not open ithe table with Ctrl 1??
-
When I refresh my pivot tables, it is annoyingly resizes my column widths. I have read some solutions saying un check LOCK option from the format menu. So I did it. It is now most of the cells are showing errors, and when I refresh my Pivot table, it STILL changes the Column Widths.. How can I solve this?
-
Can I HIDE my changes in a shared workbook, when I am not the creator/administrator? My Boss has been treating me like an imbecile when I ask for formulas to be used and tells me 'it can't be done'. I want to make things easier for me and my colleagues, but not give him the luxury of finding out our easy formulas when he doesn't deserve it.
-
Very very confusing lock unlock lock unlock