Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I know this on a PC. It is Alt+O,C,A, as explained in this question.

Can someone tell me please what the keyboard shortcut is to fit the column width to the width of the text in Excel on a Mac?

I'm using the 2011 version.

share|improve this question
1  
I don't have my Macbook with me so I can't confirm if this is possible, but have you tried assigning a custom keyboard shortcut to it? I believe Autofit Column Width should be under Format. – Kaze Mar 21 '13 at 17:21
    
Thanks for a good idea! Unfortunately 'Autofit Column Width' wasn't in there (under 'Format'). I set a shortcut that pops a window asking me to type a width in inches. I'm still looking for an Autofit solution. – Nelu Malancea Mar 21 '13 at 18:20

Although Microsoft did not include many keyboard shortcuts in their Office Suite for Mac, you can make your own for any app including Office apps. To do so:

  • Go to System Preferences and then Keyboard.
  • Select the shortcuts tab.
  • You can add any shortcut there either system-wide for any application or application specific by clicking the Plus button +, selecting Excel and recording your key combination.

In this case you must type in AutoFit Selection just as it appears on the menu in Excel. (Format > Column > AutoFit Selection)

You can choose any key combination that suits your fancy.

System Preferences Keyboard Shortcuts

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .