• Skip to main content
  • Skip to secondary menu
Productivity Portfolio logo

Productivity Portfolio

Valuing your time & technology

  • HOME
  • Tutorials
    • Excel
    • Google
    • Word
    • Outlook
    • Terms
  • Quick Tips
    • Email
    • Security
    • Web
    • Windows
    • Internet of Things
    • Cell
  • Reviews
    • Health
    • Services
    • Software
    • Hardware
  • About
    • About Me
    • Contact Page
    • Privacy Policy
  • Newsletter
  • Resources
    • Practical Gift Ideas
    • Books
    • Favorite Podcasts
    • Online Courses
    • Online Services
  • SEARCH
You are here: Home › Tutorials › Excel › Simple Methods to Copy Excel Formula Values

Simple Methods to Copy Excel Formula Values

LAST UPDATED: May 7, 2020 By Anne Hennegar

TwitterPinterestLinkedInRedditFacebookPocketEmail

Recently I was watching an Excel product review and noticed the author copy Excel values from a formula into another column. This was fine, but then he deleted the column with the formula. Sound familiar? In this tutorial, I’ll show you two faster and easier ways to copy the value and not the formula. (See the Resource section for a video demo and sample spreadsheet.)

Article Contents

  • Why Copy Formula Values
  • Method 1 – Use Copy and Paste Special Values
  • Excel Paste Values Shortcut
  • Method 2 – Use the Mouse to Clone the Column Values
  • Additional Resources
  • You Might Also Like These Excel Tutorials

Why Copy Formula Values

There are many reasons for copying formula values. Sometimes you don’t want others to know how the result was derived. Other times, you just want to make it simpler and faster for users. This is particularly true if your spreadsheet calls external resources or spreadsheets.

In the example below, I’m copying the values from a text formula that concatenates first and last names. Instead of pasting the full name into a new column such as D, I’ll overwrite the formula in C.

paste-values1Pin

Method 1 – Use Copy and Paste Special Values

This method uses buttons you already know. The difference is most people paste the formula values into a new column. They don’t realize you can paste the values into the same column.

  1. As a precaution, I like to press CTRL+ALT+F9. This forces the spreadsheet to recalculate all cells in case auto-recalculate was turned off.
  2. Click the top cell of the column you wish to copy. In this tutorial, it would be C1.
  3. Press CTRL+SHIFT+ the down arrow key to select the column.
  4. Click the Copy button from the Home tab on the ribbon.
  5. paste-values2Pin
  6. Click the bottom part of the Paste button on the toolbar, and then select the Paste Values button.
  7. paste-values3Pin

If you move through column C you should see that the formulas have been replaced with the values.

Excel Paste Values Shortcut

If you’re like me and prefer keystrokes over a mouse, here’s the shortcut sequence.

Alt + e + s + v

Method 2 – Use the Mouse to Clone the Column Values

This method is a little trickier, but I think you’ll agree that it’s the easier solution.

  1. Follow Steps 1-3 in Method 1.
  2. Move your mouse cursor to the far right of the cell until it changes to a four-headed arrow.
  3. paste-values4Pin
  4. Press your right mouse button and drag the column to the right. (Don’t worry if it looks like you’ve shifted cells up or down.)
  5. paste-values5Pin
  6. With the right mouse button still pressed, drag the column back onto itself and let go of the mouse button. A new menu should appear.
  7. From the context menu, choose Copy Here as Values Only.
  8. paste-values6Pin

Additional Resources

  • Excel Paste Value video
  • Sample spreadsheet

You Might Also Like These Excel Tutorials

  • Limit Excel Errors with Dependent Lists
  • How to Sort Excel by Color
  • Learn How to Use Excel Auto Filter
Excel Formulas & Functions For Dummies
Bluttman, Ken (Author); English (Publication Language); 400 Pages - 11/06/2018 (Publication Date) - For Dummies (Publisher)
$20.19

Disclaimer: Images from Amazon Product Advertising API. I may receive an affiliate commission on these products if you buy. Updated: 2021-01-14

TwitterPinterestLinkedInRedditFacebookPocketEmail

Filed Under: Excel, Tutorials

© 2021 · Productivity Portfolio | PO BOX 117361 Burlingame, CA 94011

I use cookies to ensure that I give you the best experience on our website. If you continue to use this site I'll figure that you are happy with that. You can find more details in the privacy policy.OKNoPrivacy policy