How it works

This function automates the process of copying cells that are formulas then pasting them as values. 

How to use it:

Step 1

Select the cells that contain formulas that are to be turned to values.

Step 2

In the ‘More’ drop down of the Formatting and Enhancing, click on ‘Copy + Paste Values’.

The function will be executed.

Step 3

The results will be that the formulas will be replaced with the values of the cells.

Scroll to Top