Four Ways To Convert Formulas to Values In Excel

Here are four different ways to convert formulas to their values in Excel:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Watch the video and you will see these four different ways that you can convert formulas to their values:

1) Copy data => Right-click => Under Paste Options select Values

2) Copy data => hold down the Menu key on your keyboard and hit V

3) Copy data => put your cursor on the edge of the data range, right-click and drag the data off the original location and back on => a menu will pop up => click on “Copy here as values only”

The following will only work with a single cell:

4) Click on the cell => in sequence hit the F2 F9 and Enter keys

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

One Response to Four Ways To Convert Formulas to Values In Excel

  1. Ejaz Ahmed April 24, 2014 at 9:09 am #

    I use:

    for each myRange in application,selection.cells
    if myRange.hasformila then
    myRange.Formula = myRange.Value
    end if
    next myRange

    And linked it to a keyboard shortcut.

Leave a Reply