Paste values in Excel for Mac
Option, then H V V, pastes values in Excel for Mac with RibbonKeys, the same sequence as Alt+H+V+V on Windows. H opens the Home tab, V opens Paste, and V is Paste Values, which that menu shows when cells are on the clipboard.
Home, Paste, Paste Special is H V S, and that opens the dialog. The older menu keys E S open Paste Special from the Edit menu, and V in the open dialog is Values.
Which paste do you need?
A plain paste brings the formulas, the formats and everything else of the copied cells. A values paste brings only what the cells show. These are the situations where the Paste dropdown has a letter for exactly that.
- A formula's result, without the formula. Copy the cells, select where they go, and type ⌥ H V V. The pasted cells hold numbers and text, not links to the cells they came from, so they do not change when the source does.
- The result and its number format. ⌥ H V A is Values & Number Formatting. Use it when a percentage, a date or a currency has to look the same where it lands.
- The result and the look of the source. ⌥ H V E is Values & Source Formatting: colours, fonts and borders come along with the numbers.
- Only the formatting. ⌥ H V R is Formatting, with no values at all. It is the way to copy a look onto cells that already hold their data.
- Rows turned into columns. ⌥ H V T is Transpose. Add ⌥ H V N for Paste Link when the pasted cells should follow the originals instead.
The keys, one letter at a time
- Copy the cells, then select the cell where the paste starts.
- Tap ⌥ by itself, and type H for the Home tab.
- Type V. The Paste button opens its dropdown, and every item of it gets a letter.
- Type the letter of the item. V is Paste Values, A Values & Number Formatting, E Values & Source Formatting.
The dropdown depends on what is on the clipboard. With cells copied it has the items above. With text copied from another app it has Keep Text Only on T and Use Text Import Wizard on U instead. Paste Special stays on S in both. RibbonKeys reads the items from the open menu, so the letters you see are the ones that apply to what you copied.
The Excel 2003 route: E S V
Windows still accepts the menu keys of Excel 2003, and many people paste values with them: Alt+E+S, then V, then Enter. RibbonKeys accepts those too. ⌥ E S presses Paste Special in the Edit menu of Excel's menu bar without opening the menu. In the dialog that opens, V picks Values, and Return is OK, as on Windows. So ⌥ E S V Return is the whole thing, and the Paste Special page has the other letters of that dialog.
On Windows, and on a Mac without RibbonKeys
On Windows the ribbon route is Alt+H+V+V and the old route is Alt+E+S+V. Excel for Mac has the same commands, in the Paste dropdown on the Home tab and as Paste Special in the Edit menu, but they have no Windows letters, so without RibbonKeys they are a mouse job. Its Command shortcuts differ from the Windows ones and reach only part of the ribbon. Excel for Mac also has a keyboard shortcut for the Paste Special dialog, Control+Command+V, after which you choose Values in the dialog.
A few things to know about values pastes
- The formulas are gone after the paste. Keep the original if you may need them again.
- A plain Paste Values brings no number format. A date can turn into a serial number and a percentage into a decimal. H V A keeps the number format and avoids that.
- The Paste dropdown only has Paste Values while cells are on the clipboard. If the letters you expected are missing, copy again.
What to press next
Pasted values often need room. After the paste, Alt HOI, ⌥ H O I, fits the columns to what they now hold. To keep the headings in view while you check a long paste, freeze the top row with ⌥ W F R.
Questions
How do I paste values only in Excel for Mac?
Copy the cells, select where they go, tap Option and type H V V. H opens the Home tab, V opens Paste and V is Paste Values. It is the same sequence as Alt+H+V+V on Windows.
How do I paste values and keep the number format in Excel for Mac?
Tap Option and type H V A, which is Values & Number Formatting. H V E, Values & Source Formatting, also brings the colours, fonts and borders of the source.
How do I paste values with the old Excel menu keys on a Mac?
With RibbonKeys, tap Option and type E S to open Paste Special from the Edit menu, then V for Values and Return for OK. It is the same as Alt+E+S+V on Windows.
Free for 7 days, with no account and no card. After that €3.99 a month or €59.99 once, including VAT.
The same licence covers Word and PowerPoint.
Needs macOS 13 or later and Excel for Mac.
Windows Excel shortcuts on a Mac · Every shortcut · RibbonKeys