How to Do Alt + N V T on Mac in Excel (PivotTable From Table/Range)

💡
Quick Answer

To do Alt + N V T on Mac in Excel, download and install Accelerator Keys, then press Option, followed by N, then V. Mac Excel opens the Create PivotTable dialog directly, so the final T is not needed.

Download Accelerator Keys for Free Now

Command: PivotTable from Table/Range

What Does Alt + N V T Do in Excel?

On Windows, Alt + N + V + T opens Insert > PivotTable > From Table/Range, which creates a PivotTable from your currently selected table or cell range. It is the fastest way to start summarizing data with a PivotTable.

The Mac Difference: You Only Need Alt + N + V

Mac Excel does not split the PivotTable button into a submenu the way Windows Excel does. Pressing Alt + N + V opens the Create PivotTable dialog directly, already set to your selected table or range — the same result as Alt + N + V + T on Windows, one keystroke shorter.

Shortcut Platform Result
Alt + N + V + T Windows Insert > PivotTable > From Table/Range
Alt + N + V Mac (Accelerator Keys) Create PivotTable dialog with selected range

Step-by-Step Guide

  1. Download and install Accelerator Keys (14-day free trial, no credit card required).
  2. Follow the simple on-screen setup instructions (just a few clicks).
  3. Select a cell inside the table or range you want to summarize.
  4. Press the Option key (works like Alt on Windows).
  5. Press N, then V — the Create PivotTable dialog opens with your range pre-filled.

This is how to do Alt + N V T on Mac in Excel with Accelerator Keys, the native ribbon and alt key shortcut solution for Mac users who get more done with Excel.

Related Links