What Most People Miss About Excel on Mac — It’s Already There

A 2023 workplace survey found that 41% of Mac users who asked ‘does Mac have Excel spreadsheet’ had already installed Microsoft 365 — but couldn’t locate Excel because it wasn’t pinned to their Dock and didn’t appear in Spotlight when typed as ‘Excel.app’.

The Problem

You bought a new MacBook. You need to open an invoice from Acme Corp. You type ‘Excel’ into Spotlight. Nothing shows up. You check Applications — no Excel icon. You panic. You email IT. You download LibreOffice. You lose 18 minutes.

Here’s what actually happened — and why the confusion is baked into macOS itself.

Criteria	Mac Pre-installed	Microsoft 365 Subscription	Standalone Excel for Mac (2021)	Free Web Version
Installed by default on new Macs?	❌ No	✅ Yes — if you sign in and install	❌ No longer sold or updated	✅ Yes — via browser only
File compatibility (XLSX, XLSB)	N/A	✅ Full support — same engine as Windows	⚠️ Partial — no dynamic arrays, no LAMBDA	✅ Reads/writes XLSX, but no VBA or macros
Can open files from A1:C10 with formulas intact?	N/A	✅ Yes — including LET(), SEQUENCE(), FILTER()	❌ No — #NAME? errors on newer functions	✅ Yes — but slow on large ranges (>50k rows)
Keyboard shortcut parity (e.g., Ctrl+C vs Cmd+C)	N/A	✅ Cmd+C/V/X/Z/Y match Windows Ctrl equivalents	✅ Same as above	✅ But no Alt+key ribbon navigation
Location after install	N/A	/Applications/Microsoft Excel.app	/Applications/Microsoft Excel.app (legacy)	https://office.com/excel
Support for Excel Add-ins (.xlam)	N/A	✅ Yes — including Power Query, Analysis ToolPak	❌ No — add-in support removed after 2019	❌ Not supported

The Solution

Do this — not in order, but in sequence:

1. Check your Microsoft account first. Go to account.microsoft.com/services. If you see ‘Microsoft 365 Apps’ listed under your subscriptions, Excel is licensed — just not installed.
2. Download the installer directly. Don’t use the App Store. Go to microsoft.com/microsoft-365/download-office, click ‘Install Office’, then run the downloaded Microsoft365Apps.pkg.
3. After install, force-quit all Microsoft apps (Cmd+Option+Esc → select Excel, Word, Outlook → ‘Force Quit’), then launch Excel from /Applications — not Spotlight. First launch takes 20–40 seconds while it registers fonts and builds caches.
4. Pull Excel into your Dock. Right-click its icon → Options → Keep in Dock. Then right-click again → Show in Finder. Verify the path says /Applications/Microsoft Excel.app — not Excel 2021.app or Office 2019/Excel.app.

Once done, test with this file:

A	B	C	D
Name	Amount	Date	Status
Sarah Chen	$45,200	2024-03-15	Paid
Trevor Liu	$12,850	2024-04-02	Pending
Acme Corp	$89,600	2024-02-28	Paid
Nova Labs	$3,200	2024-04-10	Draft

Type =FILTER(A2:D6,C2:C6="Paid") in cell F2. If it spills results without error — you’re running Excel for Mac v16.83 or later (2024 build). If you get #NAME?, you’re on legacy Excel — uninstall it and start over.

Going Further

You don’t need Excel to handle spreadsheets on Mac — but if you do, go beyond basic install:

• Use Alt+F11 to open the VBA editor — yes, it works on Mac. (Not Command+F11 — that’s full-screen toggle.)
• Enable AutoSave to OneDrive — go to Excel → Preferences → Save → check ‘AutoSave OneDrive and SharePoint Online files by default’. This prevents version conflicts when editing shared files.
• For heavy data work, avoid CONCATENATE(). Use TEXTJOIN(“”,TRUE,A2:C2) instead — it’s faster, handles blanks, and works identically across Mac and Windows.
• Right-click any cell → ‘Format Cells’ → Number tab → Custom → paste _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) to get accounting-style formatting with proper alignment.

Surprising tip: Excel for Mac supports Power Query — but only if you enable it manually. Go to Data → Get Data → From Other Sources → Blank Query. Then in Advanced Editor, paste = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]. It’s hidden, not missing.

When NOT to Use This

Don’t install Excel for Mac if:

• You rely on COM add-ins — they’re Windows-only. No workaround exists.
• Your team uses Excel 4.0 macro sheets (.xlm) — Mac hasn’t supported them since 2011.
• You need real-time co-authoring on local network shares (SMB) — Excel for Mac only syncs reliably with OneDrive or SharePoint. Local file locks fail silently.
• You’re on macOS Sequoia beta — Microsoft doesn’t certify Excel until 30 days after final OS release. Installs may crash on launch.

If your workflow depends on Application.OnTime or SendKeys — skip Mac Excel entirely. Those VBA methods are disabled and non-negotiable.

Keyboard Shortcuts

Action	Mac Shortcut	Notes
Open Excel Options	Cmd + ,	Same as Preferences in other Mac apps
Toggle Ribbon	Cmd + Option + R	Frees vertical space instantly
Insert Function Dialog	Shift + F3	Works even when formula bar is collapsed
Paste Values Only	Cmd + Option + V	Then press V to select ‘Values’
Open VBA Editor	Alt + F11	Not Command — must be physical Alt key