How to Convert Formulas to Values in Excel

Watch Video – Convert Formulas to Values

You may need to convert formulas to Values in Excel if you work with a lot of dynamic or volatile formulas.

For example, if you use the Excel TODAY function to insert the current date in a cell, and you leave it as a formula, it will update itself if you open the workbook the next day.

If this is not what you want, then you need to convert the formula into a static value.

Convert Formulas to Values in Excel

In this tutorial, I will show you various ways to convert formulas to values in Excel.

  • Using a Keyboard Shortcut.
  • Using Paste Special techniques.
  • Using a cool Mouse Wriggle Trick.

Using Keyboard Shortcut

This is one of the easiest ways to convert formulas to values. A simple keyboard shortcut trick.

Here is how to do this:

  • Select the cells for which you want to convert formulas to values.
  • Copy the cells (Control + C).
  • Paste as Values – Keyboard Shortcut – ALT + ESV

Convert Formulas to Values - Paste Special Shortcut

This would instantly convert all the formulas into static values.

Caution: When you do this, you lose all the original formulas. If you think you may need the formulas at a later stage, make a copy of the worksheet as back-up.

Also read: Convert Text To Number in Excel

Using Paste Special

If you are not a keyboard shortcuts fan, you can use the paste special option that can be accessed from the ribbon in Excel.

Here are the steps to convert formulas to values using Paste Special:

  • Select the cells for which you want to convert formulas to values.
  • Copy the cells (Control + C).
  • Go to Home –> Clipboard –> Paste –> Paste Special.

Convert Formulas to Values - Paste Special button

You can also access the same paste special option if you right click on the copied cell. Hover your mouse on the Paste Special option and you will all the options within it.

Convert Formulas to Values - Paste Special Right Click

Also read: Formulas Not Working In Excel

Using a Mouse Wriggle Trick

This is one mouse trick that not many people would know.

Here it is:

  • Select the cells for which you want to convert formulas to values.
  • Bring your mouse cursor over the outline of the selected cells. (You will see an icon of four arrows pointing in the four directions).
  • Press the RIGHT button of your mouse. Hold the button and drag the outline to the right and bring it back to its original position. As soon as you leave the mouse button, a menu would appear.
  • Click on Copy Here as Values only.
  • That’s it. It will instantly convert formulas to values in the selected cells.

Convert Formulas to Values - Mouse Tricks

Hope you found this tutorial useful.

Let me know your thoughts in the comments section.

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

2 thoughts on “How to Convert Formulas to Values in Excel”

Leave a Comment