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

On a PC this is Alt+O,C,A, as explained here.

Is there an equivalent keyboard shortcut in Excel for Mac, to fit the column width to the width of the text?

I'm using the 2011 version.

2

3 Answers

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.

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.

Step1:

• Click on the Rectangular ruler as shown in the below image.

Click on Triangle

Step2: -Keep the cursor in between the Vertical column line (Between A and B columns) and double-tap. All the text will fit into the column width.Keep cursor in between the column line

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy