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"
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!