How to Do Alt + M P on Mac in Excel (Easiest Way)

💡
Quick Answer

To do Alt + M P on Mac in Excel, download and install Accelerator Keys, then press Option, followed by M, P.

Download Accelerator Keys for Free Now

Command: Trace Precedents

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. Press the Option key (works like Alt on Windows).
  4. Press M, P to complete the ribbon shortcut.

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

What Does Alt + M P Do in Excel?

Alt + M P is the Excel trace precedents shortcut. It shows arrows from cells that feed into the selected formula, helping you understand where a formula gets its input values. This is one of the most important auditing tools in Excel for tracking down formula errors and understanding complex spreadsheet models.

When you press Alt + M P, Excel draws blue trace precedents arrows pointing from the source cells (precedents) to the active cell. Each time you press the shortcut again, it traces one more level back through the formula chain.

How to Trace Precedents in Excel on Mac

Without Accelerator Keys, tracing precedents on Mac Excel requires navigating the ribbon manually:

  1. Select the cell containing the formula you want to audit
  2. Go to the Formulas tab in the ribbon
  3. Click Trace Precedents in the Formula Auditing group

With Accelerator Keys, you can use the same Excel trace precedents keyboard shortcut (Alt + M P) that works on Windows — just press Option → M → P. This is far faster when auditing complex financial models or debugging formulas.

Common Use Cases for Trace Precedents

Shortcut Command Description
Alt + M P Trace Precedents Show arrows from cells that feed into the formula
Alt + M D Trace Dependents Show arrows to cells that depend on the selected cell
Alt + M A Remove Arrows Clear all tracer arrows from the sheet

Related Links