View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Shortcut to change view so that column widths are all wide enough to show all data?

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?