Excel Tip: How To Auto-Fit All Columns Width in One Click

How many times you have to double-click the border of the column to make its width to auto-fit the content length? I had one point considered this as a nightmare when I had one Excel spreadsheet open to find out over 20 columns that were all scrambled together.

And this quick trick will help you solve this, once for all.

1. Highlight all columns you want to set to auto-fit the width.

2. Go to Home tab, click Format under Cells section, and choose AutoFit Column Width.

Excel - column autofit

And see what happens next.

You can also use the AutoFit Row Height to auto-fit the height of the rows you highlighted as well.

If you are using Excel to manipulate the data on a regular basis, you will definitely need this.

Kent Chen

Microsoft MVP, IT Professional, Developer, Geek, and the co-founder of Next of Windows.

Last updated: 08/04/2014

Posted in: Tips & Tricks
Discover more: ,

Leave a Reply

Notify of
avatar
CastlegarGlenn
Guest

I haven’t used Excel in ages, but, after selecting the columns can’t you also just double-click Auto-Fit on one of the columns, which automatically auto-fits all the selected columns?

Kent Chen
Guest

No, they will all be updated to the same width.

wpDiscuz
Today's Top Picks for Our Readers:
Recommended by Recommended by NetLine