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.
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.
To learn more of these types of tips consider our online Beginner Course