What is the keyboard shortcut for...

**Rinocerinho** · 03-22-2010, 09:53 PM

...the 'fit all columns' functionality?
Hi, sorry for not greeting you people before.
I mean that command in which you click at the top-left "cell" (between A and 1, the point they would cross) and then double-click the separator between columns A and B. When done, all data in the current sheet will be used as limits to resize the columns sizes.

Is there a shortcut to do that without the mouse?

Thanks!

**shg** · 03-22-2010, 10:00 PM

Ctrl+A Ctrl+A Alt+oca

**Rinocerinho** · 03-22-2010, 10:15 PM

omg you're fast!
Thanks a lot!

By the way, I don't have Office 2003 and earlier, and I didn't know I could type in an old shortcut combination to access the menus.
is there a list of commands beginning with Alt+O?
Thanks in advance.

**shg** · 03-22-2010, 10:17 PM

It's the Format menu.

**Rinocerinho** · 03-22-2010, 10:26 PM

Now I get how it works. You used an old hotkey combination, right?
Just curious: can this be accomplished in the latest versions (07 and 10), by using the ribbon?

**shg** · 03-22-2010, 10:31 PM

You tried it, and ...?

**teylyn** · 03-22-2010, 10:32 PM

yes ......................

**Rinocerinho** · 03-22-2010, 10:53 PM

You tried it, and ...?

...and I couldn't since:
1- I don't even recall myself using Excel 2003 and prior, so I can't know the menu sequences
2- I don't know the precise, 'official' name for this command/functionality.