Paste Numbers styles or formula results deliberately
Shift-Command-V pastes formula results in Numbers. Option-Command-V pastes copied cell style, while Option-Shift-Command-V preserves the destination style when pasting.
Numbers · Reviewed 2026-11-05 · Review method
Platform, keyboard and verification notes
- Scope
- Numbers · macOS app; Apple Mac documentation source checks on 4 November 2026 and editorial review on 5 November 2026. No running-app compatibility test is claimed.
- Keyboard and customization
- English-language Apple documentation. Modifier and punctuation keys may differ on other keyboard layouts.. Documented defaults, not a reading of your current menu. Check the app menu and custom App Shortcuts if a binding differs; focus and selected content can change its effect.
- Review basis
- Documentation reviewed 2026-11-05 by Codex — primary-documentation and editorial review; no hands-on runtime test. These bindings were not tested in a running app for this guide.
Keyboard shortcuts for this task
| Action | Keys | Context |
|---|---|---|
| Paste formula results | Shift-Command-V | Use when the destination should receive results rather than the formula relationship. Source ↗ |
| Copy cell style | Option-Command-C | Copies styling from the current cell context. Source ↗ |
| Paste cell style | Option-Command-V | Applies copied style rather than serving as the formula-result command. Source ↗ |
| Paste preserving destination style | Option-Shift-Command-V | Pastes while retaining the receiving cell’s style. Source ↗ |
Decide whether the receiving cells need formulas or values
A report handoff may need a snapshot of calculated results, while a working model needs formulas that continue responding to inputs. Before pasting, identify which outcome the recipient table should have. A result-only paste is not interchangeable with preserving a live calculation. Inspect a pasted cell’s contents afterward rather than judging solely by the number that is displayed.
Treat appearance as another independent choice
Cell style can communicate number types and visual hierarchy, but a matching fill or font does not prove that a value is correct. Copying a style and pasting content while retaining destination style solve different presentation problems. Select only the intended destination range, and inspect headers or neighboring cells so that a style change does not conceal the structure of the table.
Make a two-table comparison
In a practice spreadsheet, create a simple calculated result and a second table for a handoff. Paste the result as a value, then change an original input and inspect whether the pasted result remains the intended snapshot. Separately try a cell-style transfer. This checks the relationship between data and appearance before you use a paste shortcut to prepare a budget, an invoice summary or another consequential report.
Sources and corrections
- Keyboard shortcuts for Numbers on Mac — Apple Support — checked 2026-11-04
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