any shortcut for double click the column width auto

  • Thread starter Sohail Gagai \(GAGAI TEXTILES\)
  • Start date
S

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
 
D

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
 
P

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
 
P

psimon

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

Alt+O, C, A
 
Top