Autofit Column width dynamically

Copper Contributor

Hello,

I am using a few Microsoft forms to gather info from colleagues and then using Power Automate to update the numerous tables in the excel sheet dynamically. I am having trouble figuring out how to get the columns to adjust their width automatically when a new response is submitted, that doesn't involve me going into the excel 70 times a day to click "Autofit Column width". Is it possible to have columns in a table resize themselves as new data is added? Thank you

0 Replies