Paste Values Shortcut in Excel for Mac (Plus Formulas, Formats and Transpose)
Quick answer: To paste values only in Excel for Mac, copy the cells with ⌘C, select the destination, press ⌃⌘V to open Paste Special, choose Values, then press Return. There is no single-key Paste Values shortcut built in by default. For the full dialog and every option, see our Paste Special guide.
How we checked: the shortcuts and options come from Microsoft's Excel shortcut list and its Mac copy-and-paste page, opened on November 3, 2026. We make the Mac Excel Shortcuts app mentioned below.
What is the shortcut for paste values on Mac?
Copy with Command-C, select the destination, press Control-Command-V to open Paste Special, choose Values, then press Return. There is no built-in single-key Paste Values shortcut by default.
Select the cells that hold the formulas or formatted data and press ⌘C.
Click the first cell of the destination.
Press ⌃⌘V. Microsoft also documents ⌃⌥V and ⌘⌥V for the same dialog.
Choose Values by clicking it or using the arrow keys.
Press Return to confirm.
To check the result, click a pasted cell and look at the formula bar: it should show the number or text, not a formula.
How do you paste values with the Ribbon?
On the Home tab, open the Paste dropdown and choose Values. This is the clearest route while you are learning, because Microsoft's Mac page lists Values among the Paste menu choices.
Which other things can Paste Special paste?
Paste Special can also paste formulas, formats, comments, validation, column widths and a transposed layout, and can combine pasted numbers with operations such as Add or Multiply.
| Paste Special option | Use it to |
|---|---|
| Values | Replace formulas with their results |
| Formulas | Paste the formulas without formatting |
| Formats | Copy only the formatting |
| Column widths | Match the width of the source columns |
| Transpose | Swap rows and columns |
| Skip blanks | Avoid overwriting existing cells with empty ones |
How do the three Paste Values variants differ in Excel for Mac?
Paste Values keeps results as displayed, Values and Number Formats adds the number format, and Values and Source Formatting adds the source's number color and font size, according to Microsoft's Mac page.
| Option | What Microsoft says it pastes | Pick it when |
| Values | Only the values, as displayed in the cells | Plain numbers and text are enough |
| Values and Number Formats | Only values and number formatting | Dates, percentages or currency must keep their look |
| Values and Source Formatting | Only values plus number color and font size formatting | The look of the source matters more than clean cells |
In Microsoft's lists, Values and Source Formatting appears in the Paste menu on the Home tab but not among the Paste Special dialog options, which offer Values and Values and number formats.
Can you use Windows-style Alt sequences to paste values?
Not natively in our tests, because Excel's KeyTips did not complete Alt sequences on Excel 16.114.1. The Mac Excel Shortcuts app, which we make, adds sequences such as Alt, E, S, V.
| Need | Native Excel for Mac | Mac Excel Shortcuts app |
|---|---|---|
| Paste Values | ⌃⌘V, V, Return | Alt, E, S, V |
| Paste Formats | Paste Special ▸ Formats | Alt, E, S, T |
| Paste Formulas | Paste Special ▸ Formulas | Alt, E, S, F |
| Paste Transpose | Paste Special ▸ Transpose | Alt, E, S, E |
The wider picture is in How to Make Excel Shortcuts Work on Mac.
What is the difference between Values and Values and Number Formats?
Plain Values pastes the underlying numbers and text and drops formatting, so dates may show as serial numbers. Values and Number Formats keeps the result and the way the number is displayed.
What does Paste Values do to dates and percentages?
Excel stores a date as a serial number, so a date pasted as plain Values into a General cell can appear as a number such as 46329; Values and Number Formats avoids that.
Worked example: November 3, 2026 is day 46329 in Excel's default 1900 date system, counted as the days after December 30, 1899. That figure was calculated by hand, and the paste itself was not captured in Excel for Mac.
Percentages follow the same logic, because 7.5% is stored as 0.075. Microsoft describes Values as the values as displayed, so test one cell first and switch to Values and Number Formats if the look changes.
A 30-second check: type a date, copy it, paste it into a blank cell with Paste Special, Values, and read the result. Note the Excel version from Excel, About Excel, if the result surprises you.
How do you turn formulas into values in the same cells?
Select the formula cells, copy them with Command-C, and without moving the selection open Paste Special, choose Values and press Return. The formulas are replaced by their results, so keep a formula copy first.
Do this before sending a file when you do not want recipients to see the working. If you may need to recalculate later, paste into a separate output area or duplicate the sheet first.
How can you paste values without opening the dialog every time?
Microsoft says Excel for Mac 16.33 or later lets you add Paste Values to the Quick Access Toolbar or assign a custom key combination, as long as that combination does not already open Paste Special.
Microsoft's Mac page gives no click-by-click steps for either route and points to its Customize the Ribbon and toolbars and Create a custom keyboard shortcut articles. Follow those for the exact menus in your Excel build.
A toolbar button needs a mouse click after copying. A custom key stays on the keyboard but needs a combination that no other Mac or Excel command uses, so test it on a copied formula cell before relying on it.
Can Paste Special do math while it pastes values?
Yes. Paste Special's Operation options Add, Subtract, Multiply and Divide combine the copied values with the values already in the destination, so one paste can apply a price rise to a whole column.
Worked example, calculated by hand rather than captured from Excel: type 1.1 in a spare cell and copy it, select prices of 100, 250 and 80, open Paste Special, choose Multiply, and the cells become 110, 275 and 88. Microsoft describes Multiply as multiplying the paste area by the copy area.
Delete the spare cell afterwards. The operation changes the destination cells in place, so keep a copy of the originals first.
What mistakes break Paste Values?
Four mistakes cause most problems: losing number formats, pasting while still editing a cell, overwriting formulas you still need, and expecting a single-key shortcut that Excel does not provide by default.
Losing number formats. Use Values and Number Formats to keep dates or currency.
Pasting while still editing a cell. If the cursor is inside a cell, Paste Special is unavailable. Press Escape first.
Overwriting your formulas. Keep a formula copy of the workbook if you need to recalculate later.
Pressing Return too early. After copying, pressing Return pastes and ends copy mode. Open Paste Special before that happens.
FAQs
What is the shortcut for paste values on Mac?
Press Control-Command-V, choose Values, then press Return after copying. Microsoft also lists Control-Option-V and Command-Option-V for opening the same Paste Special dialog on a Mac.
Is there a one-key shortcut for Paste Values in Excel for Mac?
Not by default. In Excel 16.33 or later, Microsoft says you can add Paste Values to the Quick Access Toolbar or assign a custom key combination that does not already open Paste Special.
Why does Control-Command-V do nothing?
Check that something is copied, that you are not editing a cell, and that the sheet is not protected. Also try Microsoft's alternatives, Control-Option-V or Command-Option-V, in case another app claims the first.
How do I paste values and keep number formats?
Open Paste Special with Control-Command-V and choose Values and Number Formats instead of Values. Microsoft lists that option in the Paste Special dialog on Mac.
How do I convert formulas to values in the same cells?
Copy the cells, then use Paste Special, Values on the same selection. The formulas are replaced by their results, so keep a formula copy of the workbook if you may recalculate later.
Does Paste Values keep column widths?
No. Microsoft lists Column widths as its own Paste Special option, so Values leaves the destination widths as they are. Paste the widths in a second pass if the layout matters.
Where are the Paste Values options on the Home tab?
On the Home tab, the Paste dropdown lists Paste Values, Values & Number Formatting and Values & Source Formatting, according to Microsoft's Mac page. The Ribbon route needs no keyboard shortcut at all.
Related guides
Why Excel Keyboard Shortcuts Don't Work on Mac (and How to Fix Them)
Copy, Paste and Paste Special Shortcuts on Mac: Finder, Excel, Browsers and More