Shortcut to change view so that column widths are all wide enough to show all data?

[david.karr]

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?

 

[Guest]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP