Automating Excel ce...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Automating Excel cell formatting

2 Posts
2 Users
0 Reactions
92 Views
Posts: 1103
Free Member
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
Posts: 12507
Free Member
 

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
Posts: 1103
Free Member
Topic starter
 

Super thanks!


 
Posted : 05/08/2021 11:54 am

6 DAYS LEFT
We are currently at 95% of our target!