How to resize all columns to fit text in Excel at once

If you are familiar with resizing columns or rows to fit the text in Excel, but do the step to each individual row or column, this is a quick way to resize all columns to fit text in Excel at the same time.

All you need to do is:

  • highlight the rows or columns (see below column C to F highlighted die to the ### hiding the text)
  • Hover your mouse over one of the column separating lines until you see the cursor change as shown below (column E)
  • Double click when you have this cursor.

resize all columns to fit text in Excel

As shown below, you will notice that column C and D resize to autofit the text. Column E stays the same as their is no text to autofit to.

resize all columns to fit text in Excel

To learn more of these types of tips consider our onlineĀ Beginner Course