You need to copy data in Excel but want to leave the original formulas and cell formatting behind. This is a common task when sharing final numbers or preparing data for a report. Excel provides several dedicated paste options for this purpose. This article explains the different methods to paste only the cell values.
Key Takeaways: Paste Values Only in Excel
- Paste Special > Values (V): Pastes only the calculated results of formulas, removing the formulas and all formatting.
- Keyboard shortcut Ctrl+Alt+V, then V: Opens the Paste Special dialog and immediately selects the Values option for a fast workflow.
- Right-click menu > Paste Values icon (123): Provides a one-click option to paste values directly from the context menu.
Understanding Excel’s Paste Special Options
When you copy a cell in Excel, you copy everything: the formula, the resulting value, the number format, font color, fill color, borders, and other cell properties. The standard paste command (Ctrl+V) pastes all these elements. To paste selectively, you must use Paste Special. This feature lets you choose which attributes to bring over. The most common need is to paste only the raw numbers or text that appears in the cell, which is the “Values” option. Before using any method, ensure you have first copied the desired cells using Ctrl+C or right-click Copy.
Methods to Paste Values Only
You can paste values using the ribbon, keyboard shortcuts, the right-click menu, or by adding a permanent button to your Quick Access Toolbar. The result is the same: only the visible data is pasted.
Using the Home Tab Ribbon
- Copy the source cells
Select the cell or range you want to copy and press Ctrl+C on your keyboard. You will see a moving border around the copied cells. - Click the destination cell
Click on the cell where you want the values to begin. This is your paste target. - Open the Paste Special menu
Go to the Home tab on the ribbon. Click the small arrow under the Paste button in the Clipboard group. This opens a dropdown menu. - Select the Values option
In the dropdown, under Paste Values, click the icon labeled “123”. This action pastes only the values from your copied cells.
Using Keyboard Shortcuts
- Copy the source cells
Select your data and press Ctrl+C to copy it. - Navigate to the destination
Use the arrow keys or click to select the top-left cell of your destination range. - Open Paste Special and choose Values
Press Ctrl+Alt+V on your keyboard. This opens the Paste Special dialog box. Then press the V key. Finally, press Enter. This sequence pastes the values instantly.
Using the Right-Click Menu
- Copy and select the destination
After copying with Ctrl+C, right-click on the destination cell. This opens the context menu. - Use the Paste Options
In the right-click menu, look for the Paste Options section. Hover your mouse over the different icons. Click the icon that shows a clipboard with “123” on it. This is the Paste Values command.
Common Mistakes and Limitations
Knowing what to avoid helps ensure your data is pasted correctly every time.
Pasting Values Overwrites Everything
When you paste values into a range, it completely replaces the content of those cells. If the destination cells contained formulas, those formulas are gone and replaced by static values. There is no undo for individual cells after you perform other actions. Always consider pasting to a new, empty worksheet range first if you are unsure.
Values Paste Does Not Keep Number Formatting
The standard “Values” option discards all formatting, including number formats like currency, dates, or percentages. The pasted number 0.05 will not appear as 5%. To keep the number formatting but not the formula, you must use Paste Special and choose “Values and Number Formats” or use the keyboard sequence Ctrl+Alt+V, then U.
Pasting Values From Filtered Lists
If you copy a range that includes hidden rows from a filter, pasting values will paste all the copied cells, including the hidden ones, into a continuous range. This can create unexpected duplicates. To paste only visible cells, you must use Go To Special > Visible cells only before copying, then use Paste Values.
Paste Values vs. Other Paste Special Options
| Item | Paste Values (V) | Paste Formulas (F) | Paste Formats (T) |
|---|---|---|---|
| What it pastes | Only the calculated results | Only the formulas, no values or formatting | Only cell formatting like colors and borders |
| Keyboard shortcut | Ctrl+Alt+V, then V | Ctrl+Alt+V, then F | Ctrl+Alt+V, then T |
| Use case | Create static data snapshots | Copy formula logic to a new location | Apply a consistent look to different data |
| Source formatting | Discarded, uses destination format | Discarded, uses destination format | Applied to destination cells |
| Result after paste | Static number or text | Live formula that recalculates | Data unchanged, appearance changed |
You can now replace formulas with static numbers for reporting. Try the Paste Values shortcut Ctrl+Alt+V, V to speed up your work. For more control, explore Paste Special > Values and Number Formats to keep percentages and currency symbols intact.