MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - AutoFit Column Width

September 01, 2017 - by Bill Jelen

Excel Shortcut - AutoFit Column Width

Excel keyboard shortcut to make all columns wide enough for the values in the column.

Select some cells. Alt + O C A and the column is wide enough for the longest value in the selection.

Watch Video

Video Transcript

Learn Excel From MrExcel, Podcast Episode 2144: ALT+O, C, A To AutoFit The Column.

Alright. So, here we have varying columns. I'm going to select this range, CONTROL*, and I want to AutoFit everything. ALT+O, C, A will take each column, figure out the longest value in the column, and make it fit.

Now, this is one where there's a perfectly serviceable mouse shortcut for this. If you would just choose all of these columns C through I and then double click any edge, it will do the same thing; so, ALT+O, C, A, or double-click the edge of the selected columns to make the columns automatically fit.

Thanks for stopping by. We’ll see you next time for another netcast from MrExcel.

Title Photo: mintchipdesigns / Pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.