Must have video for people in Accounting.

@Computergaga

Ай бұрын

Oh yes!!!! Thank you 😊

Awesome. I've often wondered how to get those buttons to use the styles I prefer. You've saved me both time and frustration. Thanks!

@Computergaga

Ай бұрын

That is brilliant! My pleasure, Jeff.

🎉🎉 marvelous tip! I didn't know that. Thanks Alan

@Computergaga

Ай бұрын

Thank you, Grainne.

Really interesting Alan. Many thanks 👍👍

@Computergaga

Ай бұрын

Very welcome. Thank you.

Excellent👍. Thanks Alan

@Computergaga

Ай бұрын

Thank you, Kebin.

Thank you Alan for this nice video :)

@Computergaga

Ай бұрын

My pleasure, Nader.

Thanks Alan. I find these decimal places anoying, so thanks for this hot tip. I will definitively make a tamplate file. Mike Girvin made a video about a large LAMBDA function where you could select a range and then all formulas are displayed (=LAMBDA(reference;IFERROR(TOCOL(ADDRESS(ROW(reference);COLUMN(reference);4)&" : "&FORMULATEXT(reference);2);"no formulas in range"))). But saving this as a template in a business onedrive environment was tricky, there are apparently more Book1.xlst files. But I did not try your solution to store the template in personal folder. Thanks mate!

Wow sir...Excel guru

@Computergaga

Ай бұрын

Thank you ☺️

Great those decimals always drive me mad

@Computergaga

Ай бұрын

Thank you, Brian.

Hello Alan, Also, there is an other way to store your default settings without saving template. Just, open an empty workbook and set your styles and then save as it on your desctop. Then, cut this file to your excel trust center storage folder and paste in it. when you open excel, it will open it with your style as default

@Computergaga

12 күн бұрын

Great! Thanks for the tip.

Awesome thanks 🙏

@Computergaga

Ай бұрын

My pleasure!

superb 👌👍

@Computergaga

Ай бұрын

Thank you!

Who new... Thanks

@Computergaga

Ай бұрын

Once you know, you know 👍