How to Protect and Hide Excel Formulas From Being Changed in Shared Worksheets 

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

this really helped me to protect my warehouse formulas

can you do a video on how you can put formulas in but the cell looks empty

Awesome explanation👍🏾

Thanks, Heisenberg! 😁

Thanks sir ❤❤❤

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 RU-vid 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