Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


 

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