column width shortcut

[Guest]

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!

 

[Guest]

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

 

[Gord Dibben]

Double-click on the column header border line.


Gord Dibben Excel MVP