Alternate Ways To Convert Formulas To Values In #Excel

Here are two other ways that you can use to convert formulas to their values:

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

Most of us are familiar with the traditional ways to convert formulas into their values in Excel. Copy the cell, then Paste Special=>Paste Values.

There are two other ways that are much quicker. One is for single cells only, while the other is for a range of cells.

First, for single cells only. Here are two examples of formulas. One is a simple math formula, while the other is a concatenation of text:

pv1

The formulas for the two cells are listed directly below in row 7. To convert either of these to their values, click on the cell, then hit the following keys in succession: F2 F9 Enter:

pv2

Both are now converted to their values.

When you have a range of cells, as we do here with RANDBETWEEN formulas:

pv3

You can’t use the F2 F9 Enter process. This will result in only the active cell being converted. If you try to use F2 F9 Ctrl + Enter, the result will be that ALL cells will be converted to the value of the active cell.

The best way to convert these is as follows:

1) highlight the range of cells
2) move your cursor to the edge of the highlighted range
3) RIGHT CLICK on the edge of the range
4) move the range off and then back on to the original area

When you release your mouse, you will be presented with the following menu:

pv4

Select “Copy Here as Values Only” and the formulas will now be their values.

Hope this is useful.

Happy Excelling!

Related Post

Free Download!

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

, ,

No comments yet.

Leave a Reply