Quickly Convert Formulas into Their Output Values in Excel

Add to Favorites

This tutorial teaches you how to convert a formula or function into its displayed output in Excel.

This is very important and useful when you want to freeze a formula or function so that its output value cannot change.

There is a very simply set of keyboard shortcuts that allows you to do this:

First, select the desired functions/formulas then hit:

Ctrl + C and then Alt + E + S + V and then hit Enter

So, Ctrl + C > Alt + E + S + V > Enter

Do this quickly and it will seamlessly convert all selected formulas/functions to their output value.

All we are really doing is copying the cells then pasting-special their values in place of the functions/formulas.

Here is a sample:

We have the RAND() function here and each time we update the spreadsheet (F9) these values will change:

Now, lets make these values hard-coded.

First, select the cells:

Hit Ctrl + C

Then hit Alt + E + S + V and you will see this screen:

Hit OK and you are done!

Now you can see that these values are actually numbers instead of the function RAND().

Download the spreadsheet that comes with this tutorial and you can follow the steps listed above.

I hope this helps! :)


Excel Function: RAND()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
REPT Function in Excel - Repeat Values
Tutorial: Quickly repeat a value, character, or number within a cell in Excel.  This is a neat li...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Quickly Create a Huge List of Numbers in Excel
Tutorial: Quickly create a large list of numbers in Excel using the Fill Command.  This will save ...
Compare Values in Excel - Beginner to Advanced
Tutorial: How to compare text, numbers, and dates in Excel - including case sensitive text comparis...