What Are the Pivot Table Shortcuts on Mac?

Quick Answer: Pivot tables have the thinnest keyboard shortcut coverage of any major Excel feature on Mac — inserting, refreshing, and reshaping a pivot mostly happen through the ribbon and the PivotTable Fields pane, not dedicated keystrokes. The shortcuts that do exist: Group (Shift+Option+Right Arrow) and Ungroup (Shift+Option+Left Arrow). Refresh has no default shortcut, so use Data > Refresh All. This is a companion reference — for full pivot table setup, see the complete guide linked below. Mac Excel Shortcuts app fills in actions Mac Excel leaves keyboard-less here, including Refresh and Remove Duplicates on the underlying data.

This article is a shortcut-focused companion to the full pivot table guide. It doesn't re-explain how to build a pivot from scratch — it's the fast-reference card for once you already know your way around one.

Why pivot tables are keyboard-light on Mac (and Windows)

Pivot tables are inherently drag-and-drop / dialog-driven tools — reshaping which fields go to Rows, Columns, Values, Filters doesn't map cleanly onto single keystrokes on either platform. Windows has slightly more shortcut coverage because of its Alt-key menu accelerator system (Alt+N+V to insert a pivot), which chains individual letter presses through nested menus. Mac has no equivalent, so several "shortcuts" that exist on Windows are really just menu-letter sequences that don't exist on Mac at all.

Shortcut table

  • Insert PivotTable: no default shortcut — Insert tab → PivotTable (Windows: Alt+N+V menu sequence)

  • Refresh active pivot table: no default shortcut on Mac; right-click the PivotTable and choose Refresh (Windows: Alt+F5)

  • Refresh all pivot tables/data connections: Cmd+Option+Shift+F5 (confirm, unverified)

  • Group selected items (dates, numbers): Shift+Option+Right Arrow (Windows: Alt+Shift+Right Arrow)

  • Ungroup selected items: Shift+Option+Left Arrow

  • Expand/collapse a field: click the +/- toggle, or Shift+Option+Right/Left Arrow on selected item

  • Move to next pivot field in Fields pane: Tab

  • Select entire pivot table: click any cell inside it, then Cmd+A twice (confirm behavior)

  • Delete pivot table: select entire table, then Delete

Method: Ribbon and contextual tools

Click anywhere inside a pivot table and Excel automatically shows the PivotTable Analyze and Design tabs — this is where Refresh, Field Settings, Group Selection, and Insert Slicer live. Treat the keyboard shortcuts above as accelerators for the handful of actions you repeat constantly, not as a full replacement for the ribbon.

Real-world example

You've refreshed the source data behind a monthly sales pivot and need to update it, then group the date field by month. Workflow: click any cell inside the pivot, Cmd+Option+F5 to refresh, then click a date cell in the Rows area and Shift+Option+Right Arrow to open the Grouping dialog, select Months, confirm.

Pivot housekeeping that saves time

  • Refresh on open. Right-click the pivot, choose PivotTable Options, open the Data tab and tick the option to refresh data when opening the file.

  • Keep column widths and formats. On the Layout & Format tab, tick Preserve cell formatting on update and clear the option to autofit column widths if your columns keep resizing.

  • Use a Table as the source. Convert your data to a Table before building the pivot, so new rows are included automatically when you refresh.

  • Choose a readable layout. Under Design > Report Layout, Tabular form and Repeat All Item Labels produce a pivot that is easy to copy out and filter.

  • Group dates once. Right-click a date in the Rows area, choose Group, and select months, quarters or years.

When a pivot misbehaves

  • New rows do not appear. Refresh the pivot and check that the source range, or Table, includes them.

  • Field name is not valid. A column heading in the source is blank. Give every column a heading.

  • Numbers are counted instead of summed. Some cells in that column contain text. Clean the data, then change the value field to Sum.

  • Dates will not group. The column holds text dates or blanks. Convert them to real dates first, as in our clean CSV guide.

  • Formatting disappears after refresh. Turn on Preserve cell formatting on update as above.

Common mistakes

  • Expecting a keyboard shortcut to exist for inserting a new pivot table — there isn't one by default.

  • Forgetting to refresh (Cmd+Option+F5) after changing source data.

  • Using Group on a selection that spans multiple field types.

FAQs

Why can't I find a shortcut to insert a pivot table on Mac?

Because there isn't a default one — this is one of the genuine gaps between Windows and Mac Excel. Use Insert tab → PivotTable, or assign your own custom shortcut.

Do slicers have any keyboard shortcuts on Mac?

Very few — slicers are primarily a mouse/touch tool on both platforms.

Frequently asked questions (continued)

How do I refresh a pivot table on Mac?

Right-click inside it and choose Refresh, or use Data > Refresh All. To refresh automatically, tick the refresh-on-open option in PivotTable Options.

Can I drill into the numbers behind a value?

Yes. Double-click a value cell and Excel creates a new sheet listing the source rows behind that figure.

Should I build a pivot or use formulas?

Use a pivot for quick summaries you will reshape. Use formulas such as SUMIFS when the report layout is fixed and must stay stable. The complete pivot table guide compares the approaches.

Where are Power Pivot and Data Model options?

Power Pivot is not available in Excel for Mac. See where PivotTable, Data Analysis and Power Query live on Mac.

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.