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.
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.
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.
YouTube Resize all columns to fit text in Excel
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.