Thank you for explaining the default settings and how to enable restrictions such as Hidden.

@ExcelU

7 ай бұрын

You're welcome!

this really helped me to protect my warehouse formulas

As always, great info!

@ExcelU

Жыл бұрын

Thanks :)

Great tips Jeff! Thanks!!

@ExcelU

Жыл бұрын

Thanks Wayne :)

Thanks sir ❤❤❤

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

@ExcelU

Жыл бұрын

Thank you for your kind note, and welcome aboard!

Thanks, Heisenberg! 😁

@ExcelU

8 ай бұрын

Thanks, Jesse.

Awesome explanation👍🏾

@ExcelU

11 ай бұрын

Thank you :)

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 KZread 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?

@ExcelU

9 ай бұрын

PivotTable > Options > Layout & Format > Uncheck the 'Autofit column widths on update' checkbox

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