• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Paste Special Values in Excel

July 26, 2021 by Andrew Childress
paste special values Excel

As you work in Excel, you’ll find yourself copying and pasting values within and between your spreadsheets. Here's how to paste special values in Excel.

As you work in Microsoft Excel, you’ll often find yourself copying and pasting values within and between your spreadsheets. But often, these values are tied to formulas, or contain cell references. Sometimes, you want to paste only the values, without any of the underlying formatting or references. Fortunately, this is easy to do. Let’s learn how to paste special values in Microsoft Excel.

How to Paste Special Values in Excel

Imagine a column of numbers contained in cells D1:D6. At first glance, they simply look like numbers. But if you click into any of the cells, you’ll see that these are actually references to cells located elsewhere on your worksheet. If you simply copy and paste these values, then change them later, you might create errors in your data.

In other words, you want to paste only the values, not the references and formulas contained in the cells. By default, that’s exactly how pasting in Excel would handle the data. But fortunately, you have an easy alternate option.

To paste special values in Excel, begin by clicking and dragging your cursor to select the range of data you want to copy. Here again, the range is D1:D6. Then, press Command + C on your keyboard (Control + C on Windows) to copy the data to your clipboard.

paste special values Excel

Then, click into the first cell where you want to paste your data. Right-click, and you’ll see an array of new options. Hover over the Paste Special subsection, and then choose Values from your list of options.

Paste special values in Excel

Excel will paste the data, preserving only the actual values. Formulas, references, and other formatting will be removed. This is the perfect way to paste in Excel without risking errors or corruption to your data.

How to paste special values in Excel

As you can see, it’s easy to paste special values in Excel to keep your workbook data intact.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to add color scales in ExcelAdd Color Scales in Excel
Next Post:How to Create Cell Styles in ExcelCreate new cell styles in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top