Modified on Thu, 16 Nov 2023 at 03:12 PM

Activate AutoFit to automatically adjust the width of columns each time you modify a cell.

When AutoFit is active, you can type texts and values in Excel and the columns will automatically be resized, just like if you had double clicked on the column header.

Click AutoFit again on the ribbon to deactivate this feature.

Power-user AutoFit columns in Excel automatically

Due to Excel behavior, any code running on the workbook will clear the undo stack. Because AutoFit runs a bit of code every time a cell is modified, it means that when AutoFit is active there is basically no possibility to undo changes in Excel. For this reason, we recommend you use it cautiously and only when needed.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article