any shortcut for double click the column width auto

[Sohail Gagai \(GAGAI TEXTILES\)]

hi , is there any short cut keyboard available to get the column set to the
text in it automatically , we have to it with mouse at edge of column double
click . or any short cut for complete work sheet to set the column with the
text in it.
Thankyou

 

[Don Guillett]

You could assign this to a button or a shortcut or menu bar linked to
personal.xls
Sub autofitsheet()
Columns.AutoFit
Rows.AutoFit
End Sub

 

[Pete_UK]

If you want to do several columns at once, highlight the columns by
clicking on the identifier (letter) at the top of the column and
double-click one of the column edges. If you want to select all
columns, then click at the intersection of the row and column
identifiers, then double-click a column edge to adjust the width.

Hope this helps.

Pete

 

[psimon]

This shortcut key sequence will work on the column your cell pointer
is in or all columns you highlight.

Alt+O, C, A