Here's our Microsoft Office Tip for.. January 10, 2000
Click Here to see a complete list of all of our previously released Tips!
Resizing Multiple Columns
Sometimes you may need to adjust the width of your columns in order to view the entire contents of each cell. If it's just one column, a quick fix is to simply double-click the right border of the column's header cell (the row of gray cells along the top). Doing so will increase the size of that column so that it can accommodate the longest entry in that column. You can also resize several columns at the same time by selecting multiple columns and then double-clicking the right border of any column header cell within the selection.
There are two ways to select multiple columns. You can drag the mouse pointer across the appropriate column header cells. Or, you can click a column header cell, hold down the Shift key, and then click the remaining column header cells to add those columns to the selection. The latter method allows you to create noncontiguous selections.
If you don't want to use the Best Fit property (as we just did), position the mouse pointer between any two selected column header cells. The mouse pointer will turn into the horizontal double arrow pointer. At this point, drag the borderline between the two column header cells. Excel will resize each of the selected columns accordingly. Using this method, you can also reduce the column width(s).