RibbonKeys Teams Download

Paste special in Excel for Mac

Option, then E S, opens Paste Special in Excel for Mac with RibbonKeys, the same menu keys as Alt+E+S on Windows. E opens the Edit menu and S is Paste Special.

On the ribbon the same dialog is H V S: Home, Paste, Paste Special. Once the dialog is open, V is Values, F is Formulas and T is Formats. The dialog's other letters are on the shortcut list.

What the dialog is for

Paste Special is where a paste gets more specific than the Paste dropdown allows. The dropdown has the common choices; the dialog has all of them, and it adds arithmetic. These are the jobs people open it for.

The letters of the dialog

When a sequence opens a dialog, its controls get letters: the ones Windows underlines. With cells copied, the Paste Special dialog has these.

Paste

Operation

Options

With text or a picture copied, the dialog offers other choices, and RibbonKeys gives those their letters too. Return is OK and Esc is Cancel, as on Windows. If you want to move between controls with Tab, macOS decides which controls it stops at: System Settings, Keyboard, Keyboard navigation.

Three routes to the same dialog

On Windows Paste Special has three ways in: Alt+E+S, from the menus of Excel 2003, Alt+H+V+S on the ribbon, and Ctrl+Alt+V. RibbonKeys has the first two with Option in place of Alt: ⌥ E S presses Paste Special in the Edit menu of the menu bar without opening the menu, and ⌥ H V S takes the ribbon's Paste dropdown. Excel for Mac has a shortcut of its own for the dialog, Control+Command+V, and the Edit menu, which a mouse reaches. Its shortcuts with Command differ from the Windows ones and reach only part of the ribbon.

If the dialog does not open

Paste Special is available only when something has been copied, and a command that is greyed out has no letter. If E S does nothing, copy first. If no letters appear at all, Install and troubleshooting lists what to check.

What to press next

When all you want is the values, the shorter route is on the paste values page: ⌥ H V V, with no dialog. After a paste that changed what the cells hold, Alt HOI, ⌥ H O I, fits the columns again.

Questions

What is the Paste Special shortcut in Excel for Mac?

With RibbonKeys, tap Option and type E S. It presses Paste Special in the Edit menu, as Alt+E+S does on Windows. H V S, Home, Paste, Paste Special, opens the same dialog. Excel for Mac also has Control+Command+V.

How do I paste and transpose in Excel for Mac?

Copy the cells, tap Option and type E S, then V for Values if you want values only, E for Transpose and Return for OK.

How do I multiply a range by a number with Paste Special on a Mac?

Type the number in a cell and copy it. Select the range, tap Option and type E S, then M for Multiply and Return for OK.

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