Changing the width of multiple columns.

There are 3 simple ways to change the width of multiple columns.

Take a look at the below data from an old KPI dashboard post I did a ways back. Notice that the text in each column does not fit (the columns are too small to display all the data).

Now I can change the column widths by first selecting the columns I wish to change. I do this by left mouse clicking on the letter A to highlight the entire column A. Then while holding down the left mouse button, I drag the mouse to the right until I get to column H. I then release the mouse button. The result is that all columns A – H are now selected (highlighted as in the below example.)

Next I want to double click on one of the boarders between any of the highlighted columns. In this example you can see that a double arrow appears when you position the mouse pointer between columns B and C.

If I double click on the double arrow, all highlighted columns will auto fit based on the maximum length of data in each column.

Alternatively I could also left mouse click and drag the arrow to the right or left, all the cells will adjust to the width I drag the cursor.

I personally like the double click since it spaces each column based on the data in that column.
A third way is to select all the columns on the worksheet by clicking on the select all reference.

Then from the ribbon, choose the Home tab and Format > column width or Autofit columns Width.

How do you adjust the width of multiple columns?

No comments:

Post a Comment