Excel Shortcut - AutoFit Column Width
September 01, 2017 - by Bill Jelen
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.
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