Keyboard Shortcut to Fit Column Width to Text in Mac Excel?
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.