column width shortcut

My column width is too short...displaying #######

Isn't there a short-cut to autofit data into a column???

I thought it was simply double-clicking the column but that doesn't seem to
work.

Let me know.

Thanks!

You double-click the column SEPARATOR. So to autofit column G, doubleclick
the separator between G & H. Alternatively, you can type /oca (including the
slash).
Bob Umlas
Excel MVP

"wnfisba" wrote:

> My column width is too short...displaying #######
>
> Isn't there a short-cut to autofit data into a column???
>
> I thought it was simply double-clicking the column but that doesn't seem to
> work.
>
> Let me know.
>
> Thanks!

Double-click on the column header border line.


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 13:50:24 -0700, "wnfisba"
<[email protected]> wrote:

>My column width is too short...displaying #######
>
>Isn't there a short-cut to autofit data into a column???
>
>I thought it was simply double-clicking the column but that doesn't seem to
>work.
>
>Let me know.
>
>Thanks!