To paste values only in Excel, copy the cells, then on the Home tab open the Paste menu and pick Paste Values. You get the results of your formulas, not the formulas. The same menu, and the Paste Special dialog behind it, also lets you paste only formats or skip blank cells.
Why a normal paste brings the formulas with it
Microsoft's Paste options page says a normal copy and paste carries everything: data, formatting, formulas, validation and comments. The Mac page says the same about Command+C and Command+V. To leave something out, you have to pick a specific paste option. Any attribute you don't select is left behind.
Paste values only from the Paste menu on Mac
- Select the cells that hold the data you want to copy.
- On the Home tab, select Copy.
- Select the first cell where the data should go.
- On the Home tab, select the arrow next to Paste.
- Choose Paste Values.
The options you see depend on what kind of data you copied, according to Microsoft's Mac page, so your list may not match every option named here.
Paste values only from the Paste menu on Windows
Microsoft's Paste options page uses the clipboard icon as the way in:
- Copy the cells you want.
- Select the first cell where the data should go.
- On the Home tab, select the clipboard (Paste) icon.
- Choose Paste Values.
The same page lists Values & Source Formatting in that menu, and lists All, Values, All using Source theme and All except borders among the Paste Special choices.
Which values option keeps your formatting
There are three values options, and choosing the wrong one is the most common reason pasted numbers look wrong. This is how Microsoft's Mac page describes them:
| Paste menu option | What it pastes |
|---|---|
| Paste Values | Only the values as displayed in the cells |
| Values & Number Formatting | Only values and number formatting |
| Values & Source Formatting | Only values and number colour and font size formatting |
If you pasted values and your currency symbols, percentages or dates now look like raw numbers, undo and use Values & Number Formatting instead. It keeps the number format and still drops the formulas.
Microsoft's two pages describe Paste Values differently. The Mac page says "only the values as displayed in the cells". The Paste options page says "formula results, without formatting". Neither page explains how hidden decimals or number formats are handled. If exact precision matters, compare a few pasted cells with the originals before you delete the source. If you need a number turned into fixed text in a particular format, a formula like the one in our guide to the TEXT function gives you control over that.
Use the Paste Special dialog for Skip Blanks
The Paste menu doesn't show the Skip Blanks option. On a Mac, you need the full dialog:
- Select the cells and choose Home > Copy.
- Select the first destination cell.
- Choose Home, then the arrow next to Paste, then Paste Special.
- Under Paste, pick Values (or another option).
- Under Operation, leave it on None unless you want an operation.
- Tick Skip Blanks if you need it, then confirm.
The Mac page lists these Paste choices in the dialog: All, Formulas, Values, Formats, Comments, Validation, All using Source theme, and All except borders. The Operation choices are None, Add, Subtract, Multiply and Divide.
Skip Blanks stops blank cells in the copied range from replacing values or attributes already in the paste area. It's useful when you're pasting a partial update over a full column and don't want the gaps to wipe existing data.
Make Paste Values one step on a Mac
Microsoft says that in Excel for Mac 16.33 or higher you can add "paste formatting", "paste formulas" and "paste values" to the Quick Access Toolbar or assign them custom key combinations. That's the fastest way to make paste values a one-step action on a Mac.
If you paste formulas rather than values, the Paste options page warns that cell references may need fixing afterwards. Pasting values avoids that problem, since there are no references left to break. For flipping rows and columns while you paste, see how to transpose in Excel for Mac.