If I have a worksheet where all the column widths are relatively
small, so that I can't see all of the column header value, and some of
the values, is there some sort of shortcut that can quickly expand all
the column widths so they become as wide as the widest value in the
column?

There are a couple things that you can do.

1) You can select the columns you want to resize, nove the mouse so you
have a column resize cursor and double-click

2) A simple macro:
sub FitSize()
Columns("A:Z").EntireColumn.AutoFit
end sub

"david.karr" wrote:

If I have a worksheet where all the column widths are relatively
small, so that I can't see all of the column header value, and some of
the values, is there some sort of shortcut that can quickly expand all
the column widths so they become as wide as the widest value in the
column?

Select several columns and double-click on one of the dividing lines between the
headers.


Gord Dibben MS Excel MVP

On Fri, 17 Aug 2007 17:22:17 -0000, "david.karr"
wrote:

If I have a worksheet where all the column widths are relatively
small, so that I can't see all of the column header value, and some of
the values, is there some sort of shortcut that can quickly expand all
the column widths so they become as wide as the widest value in the
column?