Excel+Double+Click+for+all+to+show

Excel Double Click for all to show

As many MS Excel users know, you can highlight a column and then through the Format menu, Column sub-menu choice, you can choose the AutoFit Selection option. What this does is make the column just wide enough to fit the longest piece of data in the selection.

It is a great thing, with no guessing necessary to make the data fit. However, we all like faster ways to do things and for this little trick, there is a two click shortcut.

Simply double click. The trick is all in where to double click.

What you need to do is move your mouse pointer over the column heading to the right side border (the little vertical line between the letters).

Your mouse pointer will then become a double sided arrow.

Now, double click. (Double clicking on the circled line above best fits column C). That's it!

The column will be resized right before your eyes! (This trick also works with multiple columns. Simply highlight the columns to change and double click on the right side of a selected column header).  