Autofit Excel Column Widths using the Mouse

User Rating:  / 0

Excel provides a neat way to autofit the width of a column using either a mouse double-click or using the built in menus. In this post I will show you how to use the mouse to automatically resize the width of a column so that the contents of the column can be seen in full.

Here is the problem; you have a table of contacts from your business. As it stands there are two problems:

• Problem 1: You can’t read the values in some columns because they are cut off by the values in the cells on their right.
• Problem 2: You can’t see any of the date values because that column is not wide enough – instead all you see is a row of #########

You could try to resize the columns one at a time by clicking and dragging on the column borders between column headers for all 6 columns, but there is an alternative way.

Mouse double click trick for resizing column widths

• Move the mouse pointer to the column border between columns you want to auto-fit
• The white cross will change to a black cross with arrows pointing left and right
• Double click the left mouse button
• Your done – the column has been autofitted!