Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Topic starter
Is it possible to automate the following?
Autofit column width
Change font size
Insert data filter into row 2
Freeze first two rows
I have a monthly file which I need to adjust in the above ways so I'd love to automate to save me a bit of time.
I have power automate if that helps?
Thanks
Posted : 05/08/2021 11:40 am
record yourself doing it as a macro.
Add a button to the quick access toolbar.
about 5 minutes work
Posted : 05/08/2021 11:49 am
Topic starter
Super thanks!
Posted : 05/08/2021 11:54 am