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

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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Sohail Gagai (GAGAI TEXTILES)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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


On Feb 8, 1:19 pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
> 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
>
> --
> Don Guillett
> SalesAid Software
> dguille...@austin.rr.com
> "Sohail Gagai (GAGAI TEXTILES)" <gagaitexti...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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

Alt+O, C, A