Quickly Resize Multiple Columns or Rows at Once in Excel

Add to Favorites

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

  1. 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, etc. or 1, 2, 3, etc.,  and hold the mouse button down while you drag across to select more columns or rows.
  2. Double-click in the header in between one of the selected columns or rows.

    Now, the columns have been made large enough so that you can see everything in them and it took only seconds to make this happen.

Doing this with rows works the exact same way except you select the rows and double-click in the header in between them.

Resize Multiple Rows or Columns at Once

  1. Select the columns or rows like we did in the previous example.  Left-click the header for the columns or rows and drag the mouse across to select multiple rows or columns.
  2. Left-click the mouse button in the header between the columns or rows that you selected and drag the mouse to the left and right for columns and up and down for the rows to adjust the size of all of the selected columns at once.
  3. That's it.

You can adjust the rows in the exact same way.


This may seem trivial, but it will save you a lot of time when dealing with large data sets, especially imported data or spreadsheets from other people.

Download the sample workbook that accompanies this tutorial so you can try this out.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Display all Formulas at Once in Excel
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Reverse Row or Column Order in a Worksheet
Macro: This macro reverses the order of a selected row or column in excel. It will completely rev...
Print All Worksheets at Once in Excel
Tutorial: How to print all worksheets at once from Excel. This saves you the time of having to go to...
View Different Parts of a Worksheet at Once in Excel
Tutorial: View different sections of the same worksheet when the sections are far apart.  This all...
Save Hours with the Selection Pane in Excel
Tutorial: How to quickly work on shapes in Excel using the Selection Pane. This includes quickly pr...