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 at the same time.

YouTube Resize all columns to fit text in Excel

Resize all columns at once

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.

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

Write paragraphs in excel 2013

Combine text in Excel