Use Paste Special in Excel for Mac
Command-Control-V opens Paste Special in Excel for Mac. Copy the source range first, choose a destination, then inspect the available paste options. A normal Command-V paste and a Paste Special operation can transfer different parts of the copied cells.
Microsoft Excel · Reviewed 2026-11-05 · Review method
Platform, keyboard and verification notes
- Scope
- Microsoft Excel · Microsoft Excel desktop for Mac; Mac section of Microsoft documentation checked 5 November 2026. Not Excel for the web.
- Keyboard and customization
- English documentation and US-style key names. Punctuation and function keys can differ on other layouts.. These are documentation-backed defaults, not a hands-on test. App settings, operating-system shortcuts, extensions and keyboard layout can change what happens. Check focus and the current app menu or shortcut settings when a binding differs.
- Review basis
- Documentation reviewed 2026-11-05 by Codex — source and editorial review; no runtime test. These bindings were not tested in a running app for this guide.
Mac shortcuts for this workflow
| Action | Keys | Context |
|---|---|---|
| Copy source range | Command-C | Select the source cells deliberately first. Source ↗ |
| Open Paste Special | Command-Control-V | Choose the available paste behavior in the dialog. Source ↗ |
| Normal paste | Command-V | Use when the default copied cell content is appropriate. Source ↗ |
| Cancel dialog | Escape | Leave without confirming an unwanted paste option. Source ↗ |
| Undo | Command-Z | Reverse a paste when the result is not intended. Source ↗ |
Decide what should cross into the destination
A copied cell can carry a formula, displayed value and formatting. Choose the appropriate paste option according to the task. For example, a static report may need the current values while a working calculation may need formulas. Read the dialog’s options instead of assuming Paste Special always means one fixed operation.
Inspect the destination before committing
Select the intended starting cell or range and check nearby data that could be overwritten. A pasted block may extend beyond the area you are currently looking at. When copying between workbooks, inspect the result carefully for changed references or unexpected presentation; a familiar-looking number alone does not prove the underlying result is correct.
Compare paste methods in a small copy
Use a disposable source cell containing a simple formula and distinctive formatting. Paste normally into one destination, then use an explicit Paste Special option in another. Inspect both the formula bar and appearance. This exercise teaches what the option actually transfers without risking a production workbook or relying on a remembered dialog position that may differ by version.
Sources and corrections
- Keyboard shortcuts in Excel — Microsoft Support, Mac section — checked 2026-11-05
Found a mismatch? Email pashaseenainc@gmail.com with your app version, macOS version, keyboard layout and the command. Please leave personal document names out.
Keep going
Right there when you need it.
Keep a compact shortcut reference in your Mac’s menu bar.
Explore the native Mac app