Automatically adjust all the cell widths in Excel to be OCD-perfect

Have you ever wondered about if there’s a quick and dirty way to set the perfect width for every cell in an Excel sheet? There is one that’s perfect!

Kalle Tolonen
March 9, 2023

No macros or VBA-sorcery needed

1. Select all the cells in a sheet by pressing CTRL + A
2. Press ALT + H + O + I
3. Enjoy a better life

This is a trick I use daily, since I use Excel to check out CSV-exports that are produced by the software that I do development on. It has saved me quite a lot of time and effort when exporting large datasets with a lot of headers.

The trick is based on these parameters:

1. H - will select HOME from the tool ribbon
2. O - will select FORMAT
3. I - will select Autofit column width