How to quickly resize multiple columns and rows at once in Excel. This avoids having to individually resize rows or columns, which can take a very long time. Auto-Fit Multiple Rows or Columns to the Size of the Data in Them Select the entire columns or rows that need to be resized. To do this, left-click the header, either where it says A, B, C, ...
Added: Dec 4, 2015