How to Copy Data from Excel Without Formula

Copying and pasting in Excel feels like second nature until you try to move data driven by formulas. You highlight a column of perfectly calculated results, paste it somewhere else, and suddenly your screen is filled with errors like #REF! or #VALUE!. This happens because you’re copying the behind-the-scenes formulas, not the final numbers you see in the cells. This guide will show you several quick and easy ways to copy the data without the formulas, so you get just the raw values you need.

Why Copy Data Without Formulas?

Before we jump into the "how," let's quickly cover the "why." You're not just fixing an annoying problem, you're using a powerful feature that makes your spreadsheets more stable and shareable. Here are a few common scenarios where this is essential:

• Sharing a Final Report: When you send a report to a client or a colleague, you want them to see the final results, not the complex formulas that created them. Pasting as values prevents them from accidentally breaking your calculations or getting confused by the underlying logic.
• Archiving Data: If you're taking a snapshot of data at a specific point in time (like month-end sales figures), you want to lock in those values. If you leave the formulas, they might update a week later when the source data changes, ruining your historical record.
• Improving Performance: Spreadsheets heavy with complex formulas, especially volatile ones like NOW() or TODAY(), can slow down your workbook. Converting calculated results to static values can significantly speed things up.
• Transferring Data to Another App: Applications like Google Sheets, PowerPoint, or a CRM don't understand Excel's formulas. You need to copy a clean set of values for the data to be usable elsewhere.

Whatever your reason, the solution is the same: use one of the "Paste Special" methods to strip away the formulas and leave only the clean data behind.

Method 1: The 'Paste Special' Keyboard Shortcut

This is the fastest and most popular method among frequent Excel users. Once you commit this shortcut to memory, you’ll be able to convert formulas to values in seconds. It might seem like a lot of keystrokes at first, but it quickly becomes muscle memory.

For Windows Users: Alt + E + S + V

1. Select the Data: Click and drag to highlight the cells containing the formulas you want to copy.
2. Copy: Press Ctrl + C on your keyboard. You’ll see the familiar "marching ants" border around your selection.
3. Select a Destination: Click on the cell where you want to paste the values. This can be right on top of the original cells or in a new location.
4. Open Paste Special: Press Alt + E + S one after another (not all at once). This command sequence opens the Paste Special dialog box.
5. Select Values & Enter: You'll see the letter 'V' is underlined for 'Values'. Press V on your keyboard, then press Enter.

That’s it. Your formula-driven results are now converted into static data points. The sequence Alt, E, S, V, Enter feels clunky at first but is lightning-fast once you get the hang of it.

For Mac Users: Ctrl + Cmd + V or ^ + ⌘ + V

1. Follow steps 1-3 from the Windows instructions (Select, Copy, choose destination).
2. Open a "Special Menu": Use the shortcut Ctrl + Cmd + V.
3. This will open the "Paste Special" dialog where you can select Values.
4. Click OK to paste your values.

Method 2: Using the Right-Click Menu

If you prefer using your mouse, the right-click context menu is your best friend. It’s more visual than keyboard shortcuts and just as effective.

1. Select and Copy: Highlight your formula cells and press Ctrl + C to copy them. You will know you've copied them because you see the selection border animate and become a "marching ant" line.
2. Right-Click a New Location: Choose where to paste. Then use your mouse and right-click to reveal a new menu prompt.
3. Right-Click Destination Cell: Right-click on the cell where you want to paste your data. A context menu will appear.
4. Select 'Paste Values' Icon: Under the "Paste Options" section, you'll see several icons. Hover over them to see what they do. Click the one that looks like a clipboard with "123" on it. This is the 'Values' option.

The moment you click the "123" icon, your data will paste without any of the original formulas. This method is incredibly intuitive for visual users who prefer clicking icons over remembering key combinations.

Pro Tip: Pasting Values and Formatting

Sometimes you want the values, but you also want to keep the nice formatting you’ve applied—like currency symbols, bold text, or cell colors. The right-click menu and Paste Special dialog have options for this!

• Values & Number Formatting: This option will copy the final values and how the numbers are formatted (e.g., as currency, percentages, or dates), but it ignores things like font color and cell borders. Look for an icon with a clipboard, "123," and a percentage sign.
• Values & Source Formatting: This is the holy grail. It copies the final values while keeping all the original formatting—colors, fonts, borders, number formatting, everything. The only thing it leaves behind is the formulas. Simply select that from the menu.

Method 3: The Right-Click, Drag, and Drop Technique

This is a lesser-known but incredibly convenient method for copying and converting data to values without having to move it far. It works especially well if you want to paste the values right next to your original data or even replace the formulas with their values directly.

1. Select Your Cells: Highlight the cells with the formulas.
2. Hover to Get the Fill Handle: Move your cursor to the edge of the selection border until it changes into a four-way arrow crosshair.
3. Right-Click and Drag: Instead of left-clicking, right-click the border and drag the selection to an adjacent location. If you want to replace the original cells, just drag them away one cell and then drag them back to the exact same spot.
4. Release the Mouse Button: When you release the right mouse button, a special menu will pop up.
5. Choose 'Copy Here as Values Only': Select this option from the menu.

Your data instantly pastes as static values. This technique is fantastic for quickly creating a static copy of a table right next to the original, allowing you to compare, archive, or work with a non-dynamic version of the data.

Final Thoughts

Mastering a simple copy-and-paste of values in Excel is a fundamental skill that moves you from a basic user to someone who can confidently prepare clean, stable, and shareable reports. Whether you prefer the speed of keyboard shortcuts or the clarity of a right-click menu, the key is knowing how to use 'Paste Special' to separate your final results from the formulas used to calculate them.

Dealing with tedious manual steps like this is a classic part of spreadsheet analysis, but it's often a sign that your reporting process could be more automated. After years of the platform-hopping, data-exporting, and spreadsheet-stitching routine ourselves, we built Graphed to eliminate this busywork entirely. Instead of pulling data into Excel and manually creating reports, we connect your data sources directly. You can simply ask a question in plain English like, "show me website sessions by country for the last 90 days," and instantly get a live, automated dashboard—no copy-pasting required.