Keyboard Shortcut to Fit Column Width to Text in Mac Excel?

Solution 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.

Solution 2:

Sorry if may sound slightly off the topic, but for ease,

1. Cmd ⌘ + A
2. Double click (mouse) on any column divider on top

This gives autofit column width of an active worksheet. To avoid any potential overlapping shortcuts.