How To Copy Values Without Formulas On Excel – Using Paste Special Values Option

Copying values without formulas in Excel requires using the Paste Special feature and selecting the Values option. If you’ve ever tried to copy a cell with a formula and paste it elsewhere, you know the formula comes along—which can mess up your data. This guide shows you exactly how to copy values without formulas on Excel, step by step.

You don’t need to be an Excel expert. Just follow these simple methods, and you’ll be pasting clean numbers in no time. Let’s get started.

Why You Need To Copy Values Without Formulas

Formulas are powerful, but they can cause problems when you share data. For example, if you copy a cell with =A1+B1 and paste it somewhere else, Excel tries to recalculate. This might break your numbers or show errors.

By pasting only the values, you keep the final results. This is essential for reports, presentations, or sending data to colleagues who don’t need to see your formulas.

Method 1: Using Paste Special

This is the most common way. It works in all recent versions of Excel, including 2016, 2019, 2021, and Microsoft 365.

Step-By-Step Instructions

Select the cells with formulas you want to copy.
Press Ctrl + C (or right-click and choose Copy).
Click on the destination cell where you want the values.
Right-click and choose Paste Special from the menu.
In the dialog box, select Values under the Paste section.
Click OK.

That’s it. Your formulas are gone, and only the numbers remain. You can also use the keyboard shortcut: Alt + E + S + V then Enter.

Why This Works

The Paste Special command tells Excel to ignore the formula and only paste the calculated result. It’s a simple but powerful trick every Excel user should know.

Method 2: Right-Click Menu Shortcut

If you prefer using the mouse, there’s an even faster way. Excel’s right-click menu now includes a direct “Values” option in some versions.

Steps

Copy your formula cells (Ctrl + C).
Right-click on the destination cell.
Look for the paste options icons. You’ll see a clipboard with “123” on it.
Click that icon. It pastes only the values.

This method is slightly faster than opening the full Paste Special dialog. It’s available in Excel 2013 and later versions.

Method 3: Keyboard Only (No Mouse)

For power users who hate taking their hands off the keyboard, this method is perfect. It uses a series of key presses.

Keyboard Shortcut Sequence

Select and copy your formula cells (Ctrl + C).
Move to the destination cell.
Press Alt + E (this opens the Edit menu).
Press S (for Paste Special).
Press V (for Values).
Press Enter.

It sounds like a lot, but once you practice, it takes less than two seconds. This is one of the fastest ways to copy values without formulas on Excel.

Method 4: Using The Home Tab

If you prefer using the ribbon, this method is straightforward. It’s great for beginners who want visual cues.

Steps

Copy your formula cells.
Go to the Home tab on the ribbon.
Find the Clipboard group.
Click the dropdown arrow under Paste.
Select Values (it looks like a clipboard with 123).

This method is identical to the right-click shortcut but uses the ribbon instead. Choose whichever feels more natural to you.

Method 5: Paste Values With A Mouse Drag

Did you know you can copy values by dragging? This trick works when you want to replace formulas in the same cells.

How To Do It

Select the formula cells.
Hover over the border of the selection until you see a four-sided arrow.
Right-click and drag the selection to a nearby empty cell.
Release the right mouse button.
Choose Copy Here as Values Only from the menu.

This method is less common but very handy when you’re working with small datasets. It’s a hidden gem in Excel.

How To Copy Values Without Formulas On Excel For A Whole Column

Sometimes you need to copy an entire column of formulas. The same methods work, but here’s a tip to make it faster.

Quick Column Copy

Click the column header to select the entire column.
Copy it (Ctrl + C).
Right-click the destination column header.
Choose Paste Special > Values.

This pastes all values in one go. It’s much faster than copying cell by cell.

Common Mistakes To Avoid

Even experienced users sometimes make errors. Here are a few pitfalls and how to avoid them.

Forgetting to copy first: You must copy the cells before using Paste Special. If you just right-click without copying, the option is grayed out.
Pasting over formulas: If you paste values onto the same cells, you lose the formulas permanently. Make sure you paste to a new location if you want to keep the originals.
Using regular paste: Pressing Ctrl + V pastes the formula, not the value. Always use Paste Special or the values icon.

When To Use Each Method

Different situations call for different approaches. Here’s a quick guide.

Quick one-off paste: Use the right-click menu shortcut (Method 2).
Repeated pasting: Use the keyboard shortcut (Method 3) for speed.
Teaching beginners: Use the Home tab (Method 4) for clear visual steps.
Replacing formulas in place: Use the drag method (Method 5).

How To Copy Values Without Formulas On Excel Using Mac

Excel on Mac works slightly differently. The Paste Special feature is still there, but the shortcuts are different.

Mac Instructions

Copy the formula cells (Command + C).
Go to the destination cell.
Click Edit in the menu bar.
Select Paste Special.
Choose Values and click OK.

You can also use the shortcut Control + Command + V to open Paste Special directly. Then press V for Values.

Using The Paste Values Shortcut In Excel Online

Excel Online (the web version) also supports this feature, but the interface is simpler.

Steps For Excel Online

Copy your formula cells.
Right-click the destination cell.
Choose Paste Special.
Select Values.

There’s no keyboard shortcut for Paste Values in Excel Online. You’ll need to use the mouse.

Advanced Tip: Copy Values With A Macro

If you copy values frequently, you can automate it with a simple macro. This is for advanced users who are comfortable with VBA.

Simple Macro Code

Sub PasteValues()
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
End Sub

Assign this macro to a button or a keyboard shortcut. Then you can paste values with one click.

How To Copy Values Without Formulas On Excel And Keep Formatting

Sometimes you want the values but also the original formatting. Here’s how.

Paste Values With Formatting

Copy the formula cells.
Right-click the destination.
Choose Paste Special.
Select Values and Number Formats.

This option keeps the number formatting (like currency or percentages) but removes the formulas. It’s a good compromise.

What About Copying Values Across Workbooks?

Copying values between different Excel files works the same way. Just copy from one workbook, switch to the other, and use Paste Special with Values.

One thing to watch: if the source workbook has external references, pasting values removes those links. This can be a good thing if you want to break dependencies.

How To Copy Values Without Formulas On Excel For Multiple Sheets

If you have formulas on multiple sheets, you can’t copy them all at once with Paste Special. You’ll need to do each sheet separately.

However, you can group sheets first. Select all sheets by holding Ctrl and clicking each tab. Then copy the cells. When you paste, it will paste values on all selected sheets.

Frequently Asked Questions

How Do I Copy Values Without Formulas In Excel Using Keyboard Only?

Use the shortcut Alt + E + S + V then Enter. This opens Paste Special and selects Values.

Can I Copy Values Without Formulas In Excel For A Range Of Cells?

Yes. Select the entire range, copy it, and use Paste Special with Values on the destination range.

What Is The Difference Between Paste Values And Paste Formulas?

Paste Values pastes only the calculated results. Paste Formulas pastes the formula itself, which will recalculate in the new location.

How Do I Copy Values Without Formulas In Excel On A Mac?

Use Command + C to copy, then go to Edit > Paste Special > Values. Or use the shortcut Control + Command + V.

Why Is Paste Special Grayed Out In Excel?

This usually happens because you haven’t copied anything first. Make sure you copy the cells before trying to paste.

Final Thoughts

Learning how to copy values without formulas on Excel is a basic but essential skill. It saves time, prevents errors, and makes your data cleaner. Whether you use the right-click menu, keyboard shortcuts, or the ribbon, pick the method that feels best for you.

Practice these steps a few times, and soon it will become second nature. Your spreadsheets will be more reliable, and your colleagues will thank you for not sending them broken formulas.

If you run into any issues, just come back to this guide. The methods here work across all modern versions of Excel, so you’re covered no matter what setup you have.