Guides, shortcut references, and Windows-to-Mac Excel tips from the team behind the Excel Shortcuts app.
A Mac Excel shortcuts cheat sheet: the 30 essential built-in shortcuts with Windows equivalents, plus 120 commands with Ribbon, mouse and keyboard routes.
A verified reference of every shortcut Mac Excel Shortcuts app currently supports — 58 keystroke sequences across Paste Special, formatting, filtering, and more, organized by category with old-Windows-shortcut-to-Mac-action tables.
A side-by-side Windows-to-Mac Excel shortcut cheat sheet: every common Windows shortcut, its Mac equivalent, and whether it works natively, needs a remap, or needs a Ribbon-sequence tool.
Alt and Option are the same key on a Mac (⌥). Where to find it, how it differs from Windows Alt, which shortcuts map to Command or Control, and how to run Alt-key Excel sequences.
Excel keyboard shortcuts not working on your Mac? Find the cause and fix it step by step, from Windows-to-Mac key differences to function-key settings.
How using keyboard sequences makes simple functions like Paste Special super fast in your Excel workflows
Save is ⌘S and Save As is ⇧⌘S in Excel for Mac, with F12 as the Windows-style alternative. Here is how each works, how AutoSave changes things, and how to save as CSV UTF-8 or PDF.
Read moreUndo is ⌘Z in Excel for Mac. Redo is ⌘Y or ⇧⌘Z. Here is what each does, what cannot be undone, and what to do when Undo is greyed out.
Read moreOn a Mac, Ctrl+; inserts today's date and ⌘; inserts the current time. Here is how to insert both, when to use TODAY() and NOW() instead, and the common mix-up.
Read moreShift+F11 adds a new sheet in Excel for Mac, and Option with the left or right arrow moves between sheets. Here are the shortcuts, the fn-key catch, and what to do about the Ctrl versions.
Read moreExcel for Mac has native shortcuts for borders (⌘⌥0) and Format Cells (⌘1) but none for Format Painter or fill colour. Here is what exists, and the workarounds for the rest.
Read moreF2 edits the active cell in Excel for Mac, but on most MacBooks you need Fn+F2. Learn the Control+U alternative and what to do when F2 does nothing.
Read moreOpen Go To with Control+G or F5, then click Special. Select blanks, formulas, constants and visible cells in Excel for Mac, with the shortcuts and examples.
Read morePress ⌘T or F4 (Fn+F4 on most MacBooks) to add $ signs and cycle absolute, mixed and relative references in Excel for Mac, with clear examples.
Read moreKarabiner-Elements remaps keys for free; Mac Excel Shortcuts runs Windows Ribbon sequences like Alt, E, S, V. Compare setup, cost and reliability for Excel.
Read moreBetterTouchTool handles gestures and custom triggers; Mac Excel Shortcuts runs Windows Ribbon sequences like Alt, E, S, V. Compare setup, cost and upkeep for Excel.
Read moreKeyboard Maestro automates anything you build; Mac Excel Shortcuts runs Windows Ribbon sequences like Alt, E, S, V out of the box. Compare setup, cost and upkeep.
Read morePaste Special on Mac Excel is ⌃⌘V, not Alt+E+S+V. Every option, four ways to open it, and how to get one-key and Windows-style versions.
Read moreA Mac Excel shortcuts cheat sheet: the 30 essential built-in shortcuts with Windows equivalents, plus 120 commands with Ribbon, mouse and keyboard routes.
Read moreWhere each Windows key lives on a Mac: Ctrl, Alt, the Windows key, Backspace and Delete, Home and End, Page Up and Down, Print Screen, Enter and more, with the Mac key or shortcut that replaces each one.
Read moreWhat each Mac modifier key does, its symbol, and its Windows counterpart: Command, Option, Control, Shift and Fn. Includes how to read shortcut symbols and how to remap modifier keys.
Read moreOffice for Mac shortcuts not working? Check the Fn key setting, macOS shortcut conflicts, Windows-only shortcuts, keyboard layout, remapping tools and Office updates, in order of how often each one is the cause.
Read moreOn a Windows or external keyboard connected to a Mac, Alt acts as Option and the Windows key acts as Command. How to swap them, set up Mac/Windows switches, and fix an Alt key that does nothing.
Read moreEvery copy and paste shortcut worth knowing on a Mac, by app: the basics, paste and match style, moving files in Finder, Paste Special in Excel, and plain-text paste in browsers and Google Sheets.
Read moreThe Paste Values shortcut in Excel for Mac is Cmd+Ctrl+V, then V, then Return. Steps for pasting values, formulas, formats and a transposed range, plus the Ribbon route and common mistakes.
Read morePaste Special greyed out or missing in Excel for Mac? Usually nothing is on the clipboard, the cell is in edit mode, the sheet is protected, or the copy was cancelled. Fixes in order of likelihood.
Read morePaste without formatting on a Mac: Option+Shift+Command+V in most apps, Command+Shift+V in browsers and Google Docs, and Paste Special in Excel and Word. Includes how to turn it into a single shortcut.
Read moreWhat the common Windows Alt shortcuts in Excel become on a Mac: Alt+Enter, Alt+=, Alt+Tab, Alt+F4, Ctrl+Alt+V and the Alt ribbon sequences, with the exact Mac keys from Microsoft and when you need an app.
Read moreHow function keys work in Excel for Mac: the system setting that makes F1 to F12 act as standard keys, when you need Fn, and the F-key shortcuts Microsoft documents (F2, F4, F5, Shift+F5, Shift+F11, Shift+F14).
Read moreHow to use F4 in Excel for Mac: toggle absolute and relative references with F4 or Cmd+T while editing a formula, what the four states do, and how Cmd+Y repeats or redoes your last action.
Read moreWhere to find PivotTable, Data Analysis, Solver, Power Query, the Developer tab, the VBA editor and Options in Excel for Mac, with the menu path for each and the Windows location it replaces.
Read moreExcel keyboard shortcuts broke after a macOS update? Check the function key setting, new system shortcut conflicts, Accessibility and Input Monitoring permissions, remapping tools and Office updates.
Read moreArrow keys scrolling the sheet instead of moving the selection in Excel for Mac? Turn off Scroll Lock with Shift+F14, use Cmd+Arrow instead of Ctrl+Arrow, and check edit mode and function key settings.
Read moreWhat accelerator keys, access keys, hotkeys and keyboard shortcuts mean in Excel, how they differ, and which of them exist natively on a Mac. Includes how Windows Alt sequences can be added to Excel for Mac.
Read moreThe Mac Excel shortcuts for Find, Replace, Go To, AutoSum, Fill Down, Fill Right, current date and time, and a new sheet, with the Windows equivalent for each, taken from Microsoft documentation.
Read moreThe Ctrl key is still on your Mac, but most Windows Ctrl shortcuts now use Command. Here's which ones moved, which stayed on Control, and the Excel exceptions that trip people up.
Read moreThere's no single Ctrl+Alt+Delete on a Mac. Here's what to press instead to force quit a frozen app, open the Task Manager equivalent, lock your screen, or restart safely.
Read moreExcel for Mac has no built-in Merge & Center shortcut. Here's how to merge and unmerge cells with the Ribbon, Format Cells or a custom shortcut, plus the alternative that won't break sorting.
Read moreThe keyboard shortcuts to insert and delete rows and columns in Excel for Mac, why they sometimes open a dialog instead, and fixes for when Insert is greyed out.
Read moreIn Excel for Mac, Alt+Enter becomes Control+Option+Return. Here's how to add line breaks inside a cell, wrap text with or without a shortcut, and fix rows that won't resize.
Read moreAn honest, up-to-date comparison of Excel for Mac and Windows: shortcuts, Power Query, Power Pivot, VBA, add-ins, Python and Copilot — plus what breaks when you share files.
Read moreAn honest comparison of Karabiner-Elements, BetterTouchTool, Keyboard Maestro, macOS App Shortcuts and Excel's own tools for getting Windows Excel shortcuts back on a Mac.
Read moreAlt and Option are the same key on a Mac (⌥). Where to find it, how it differs from Windows Alt, which shortcuts map to Command or Control, and how to run Alt-key Excel sequences.
Read moreAlt+Tab on a Mac is ⌘Tab — but it switches applications, not windows. Here is how to cycle windows, switch within one app, and get closer to true Alt+Tab behaviour.
Read moreAlt+F4 closes a program on Windows. On a Mac, ⌘Q quits an app and ⌘W closes the current window or workbook — and the difference matters. Here is when to use each.
Read moreIf the Option/Alt key on your Mac stops working — no accents, no ⌥ shortcuts, a stuck modifier — work through these fixes: modifier remapping, Sticky Keys, a stuck key, external keyboards, and app conflicts.
Read moreWindows Alt codes (Alt+0169 for the copyright sign) don't work on a Mac. Use Option-key combinations, the Character Viewer (⌃⌘Space) and press-and-hold instead. Reference table included.
Read moreKeep your Windows Excel muscle memory on a MacBook. Press Command for everyday shortcuts, add Mac Excel Shortcuts app (no setup) for Windows Ribbon sequences, and see how Karabiner and Parallels compare.
Read moreMoved to a MacBook and dreading relearning every Excel shortcut? You mostly don't have to. Here's what carries over, what to remap, and what to stop worrying about.
Read moreYes — several. A rundown of the apps that make Windows Excel shortcuts work on a Mac, from free key remappers to Windows-style Ribbon sequence tools, and which one fits your problem.
Read moreWhat Excel shortcuts work on a new MacBook with no extra software, the two settings to change first, and where the built-in limits are.
Read moreStep-by-step: remap Windows Excel shortcuts on a Mac using Karabiner-Elements, macOS App Shortcuts, and Excel macros — including a ready per-app Ctrl-to-Command rule.
Read moreIf you don't care how it works and just want Windows Excel shortcut keys to function on your Mac, here's the shortest path — plus what to expect from each option.
Read moreCan Karabiner-Elements replicate Windows Excel Alt-key Ribbon sequences on a Mac? What's actually possible, how to build a limited version, and where it breaks down.
Read moreWindows Excel Ribbon Access Key sequences (Alt, H, O, I) don't exist in Excel for Mac. Here's why, the manual workarounds, and the tools that bring the sequences back.
Read moreLooking for a Mac equivalent of the Windows Accelerator Keys / Ribbon Key Tips workflow for Excel? Here are the tools that come closest and how they compare.
Read moreA shortlist of Windows-style accelerator / Ribbon-sequence apps and remappers for Excel on Mac, with what each covers, what it costs, and who it's for.
Read moreA side-by-side Windows-to-Mac Excel shortcut cheat sheet: every common Windows shortcut, its Mac equivalent, and whether it works natively, needs a remap, or needs a Ribbon-sequence tool.
Read moreThree ways to get your Windows Excel shortcuts working on a Mac — a native shortcut tool, a Windows VM, and dual-boot Boot Camp. Here's what each actually costs, what each actually fixes, and which one fits your situation.
Read moreA verified reference of every shortcut Mac Excel Shortcuts app currently supports — 58 keystroke sequences across Paste Special, formatting, filtering, and more, organized by category with old-Windows-shortcut-to-Mac-action tables.
Read moreOn a MacBook, precisely dragging Excel's fill handle can be tedious. You can replicate the fill handle using native keyboard shortcuts:
Read moreBuild fast, refreshable summaries from thousands of rows without formulas. Insert a PivotTable via the Ribbon, menus, or mouse on Mac Excel, then drag fields into Rows, Columns, Values, and Filters.
Read moreImport via Data > Get Data > From Text/CSV, remove duplicates, trim whitespace, fix data types, and split packed fields — a repeatable CSV cleanup workflow for Mac Excel in under 15 minutes.
Read morePivot tables have the thinnest keyboard coverage in Mac Excel. The shortcuts that do exist — Group, Ungroup, Refresh — plus why most pivot actions stay mouse-driven on both platforms.
Read moreMac Excel has no Alt-key Ribbon Access Key system. This searchable reference covers the Cmd-based shortcuts and tab buttons that replace it, organized by ribbon tab.
Read moreWindows Excel lets you press Alt then a letter to walk the Ribbon. Mac Excel has no Access Key system — here is what replaces it: menu-bar navigation and direct Cmd shortcuts.
Read moreExcel has no built-in keyboard shortcut for Freeze Panes on Windows or Mac. Here is how to freeze rows/columns fast, and how to assign your own shortcut if you want one.
Read moreThe AutoFilter toggle on Mac Excel is Control+Shift+L — identical to Windows. A quick reference for opening, navigating, and clearing filters entirely from the keyboard.
Read moreRoughly 90% of Windows Excel shortcuts convert by swapping Ctrl for Cmd. A full mapping table covering the 10% that don’t — function keys, Paste Special, AutoSum, and navigation.
Read moreThe mapping table is the easy part. Here is the mindset shift and the 10 shortcuts that cause the most repeated stumbles for Windows-to-Mac Excel migrators.
Read moreA single printable page organized by task — filtering, freezing, formatting — so you can find the shortcut you need in under two seconds during your first month on Mac Excel.
Read moreBeyond the well-known Cmd shortcuts, Mac Excel has lesser-known combos even experienced users miss — from creating named ranges to Option-drag for instant cell duplication.
Read moreF4 works in Excel for Mac for both repeat-last-action and toggling absolute references — but macOS reserves bare F-keys for system functions, so the keypress never reaches Excel.
Read moreData analysts live in filtering, sorting, and pivot tables. Here is the Mac shortcut set for the analyst core loop — data cleaning speed, formula-heavy analysis, and pivot basics.
Read moreConsultants move fast across dozens of client workbooks a week. The Mac shortcut set for data manipulation, client-ready formatting, and working across many open files.
Read moreMost accounting workflows work identically to Windows on Mac Excel once you swap Ctrl for Cmd — except number-format and insert/delete shortcuts, which stay on Control.
Read moreFinancial modeling on Mac Excel works just as well as Windows once you swap Ctrl-based muscle memory for Cmd. The shortcuts finance pros use daily: auditing, references, formatting, navigation.
Read more13 concrete tips for finance pros switching to Mac Excel: relearn Cmd as your primary modifier, keep Ctrl+Shift+L for filters, and rebuild your Quick Access Toolbar habits.
Read morePull raw data into a clean Table, summarize with a PivotTable, build supporting charts, and save a template so next month’s report takes 15 minutes instead of 2 hours.
Read moreBuild a three-statement or DCF model without touching the trackpad — Command-Arrow to navigate, F2 to edit, F4 for absolute references, and Command-backtick to audit formulas.
Read moreBuild PivotTables/PivotCharts from clean source data, add Slicers so viewers can filter without touching formulas, and arrange everything on a polished Dashboard tab.
Read moreMac Excel Shortcuts app helps you work faster in Microsoft Excel by letting you trigger ribbon commands, navigate menus, and execute actions entirely from the keyboard. To do this reliably, macOS requires two privacy permissions.
Read moreHow using keyboard sequences makes simple functions like Paste Special super fast in your Excel workflows
Read moreExcel keyboard shortcuts not working on your Mac? Find the cause and fix it step by step, from Windows-to-Mac key differences to function-key settings.
Read moreFilter Excel data on a Mac without touching the mouse. Learn the native keyboard shortcuts to turn filters on, open a filter list, and clear filters.
Read moreSort rows, dates, names, and multiple columns in Excel for Mac without separating records or losing your headers. Ribbon, keyboard, and MacCove methods.
Read moreKeep headers and key columns visible while scrolling in Excel for Mac. Freeze the top row, first column, or both with Ribbon, keyboard, and MacCove methods.
Read moreSwitching from Windows to Mac shouldn't mean relearning a decade of muscle memory. Here's the story behind the app.
Read moreThe Windows Excel shortcuts you already know, finally working natively on your Mac. Here are five you'll use every single day.
Read more