RibbonKeys Teams Download

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.

The keys, one letter at a time

  1. Copy the cells, then select the cell where the paste starts.
  2. Tap ⌥ by itself, and type H for the Home tab.
  3. Type V. The Paste button opens its dropdown, and every item of it gets a letter.
  4. 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

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.

Download RibbonKeys

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