Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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. –  Ellesa 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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.