Office for Mac Issues

How to Use AutoFit Row Height and Column Width Shortcuts in Excel for Mac

John Wilson Oct 12, 2026 868 views

Question details

The user is looking for a way to quickly AutoFit row height and column width in Excel for Mac, as the standard Windows Alt-key ribbon shortcuts are not supported.

How to Use AutoFit Row Height and Column Width Shortcuts in Excel for Mac

Product: Excel for Mac
Device & OS: macOS
Scenario: Adjusting row and column sizes to properly fit cell content without having to manually drag boundaries, specifically seeking a keyboard shortcut approach.
Observed behavior: Excel for Mac does not provide the same Alt-key menu sequences as the Windows version, requiring users to rely on the macOS menu bar or configure custom keyboard shortcuts.

Before you start

Ensure you have selected the specific rows, columns, or the entire spreadsheet you want to adjust before applying any AutoFit commands.

Solution 1Recommended

Create a Custom AutoFit Keyboard Shortcut in macOS

Since Excel for Mac lacks default Alt-key shortcuts, creating a custom macOS keyboard shortcut is the most efficient permanent solution for keyboard users.

macOS allows you to map custom keyboard shortcuts to specific menu commands for any application. By mapping the exact menu path for AutoFit, you can recreate a quick shortcut experience.

Open macOS System Settings

Click the Apple menu in the top-left corner of your screen and select System Settings (or System Preferences on older macOS versions).

Navigate to App Shortcuts

Go to Keyboard, click on Keyboard Shortcuts, and then select App Shortcuts from the left sidebar.

Add Excel and Define the Command

Click the '+' button, choose Microsoft Excel from the Application dropdown, and type 'Format->Row->AutoFit' or 'Format->Column->AutoFit Selection' exactly as it appears in the Excel menu.

Assign a Key Combination

Click the Keyboard Shortcut box, press your desired key combination (e.g., Control+Option+A), and click Done.

Create a Custom AutoFit Keyboard Shortcut in macOS

Menu Path Accuracy: The menu title must exactly match the wording in Excel's menu bar, including capitalization and standard macOS arrow formatting (->) if nesting.

Solution 2

Use the Boundary Double-Click Method

If you prefer using a mouse or trackpad, double-clicking the column or row boundary is the fastest native method requiring no setup.

Solution 3

Access AutoFit via Menu Bar Navigation

You can use macOS native menu bar shortcuts to navigate to the AutoFit command without touching your mouse.

Free Microsoft Office alternative

Try WPS Office for Mac for a Seamless Spreadsheet Experience

If you are frustrated by missing shortcuts or UI differences in Excel for Mac, consider WPS Office. It provides a highly compatible, familiar interface with full support for Microsoft Excel formats natively, ensuring your workflow remains fast and uninterrupted without complex workarounds.

1. Download WPS Office: Visit the official WPS website and download the macOS version of WPS Office.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel (.xlsx) files directly.
3. Edit with Ease: Enjoy a familiar interface with native shortcuts and quick cell formatting tools.

Completely free and lightweight Mac spreadsheet applicationFully compatible with Microsoft Excel (.xlsx, .xls) formatsFamiliar user interface requiring no steep learning curveBuilt-in intuitive cell formatting and easy AutoFit features

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the Alt key work for ribbon shortcuts in Excel for Mac?

Microsoft Office for Mac does not natively support the Windows-style Alt-key ribbon navigation feature. Mac users must rely on standard macOS keyboard shortcuts, custom app shortcuts, or the menu bar navigation instead.

Can I AutoFit all columns in an entire Mac worksheet at once?

Yes. Click the 'Select All' triangle button in the top-left corner of your spreadsheet grid (where the row numbers and column letters intersect), then simply double-click any column boundary line.

Where can I request Microsoft to add Alt-key shortcuts to Excel for Mac?

You can submit feature requests or vote on existing ones through the official Microsoft Feedback Portal. Many Mac users have requested parity with Windows keyboard shortcuts there.

Office App Problems