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

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast
  • episode 2144 alt oca to autofit the
  • column alright so here we have varying
  • columns I'm going to select this range
  • control asterisk and I want to auto fit
  • everything alt OCA 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 see
  • through I and then double click any edge
  • it will do the same thing so all OCA or
  • double-click the edge of the selected
  • columns to make the columns
  • automatically fits thanks for stopping
  • by will see you next time for another
  • net cast from MrExcel

Title Photo: mintchipdesigns / Pixabay

Bill Jelen is the author / co-author of
Power Excel With MrExcel - 2017 Edition

This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.