# How to Replace Formula With Value in Excel & Google Sheets

*This article will demonstrate how to replace formulas with values in Excel and Google Sheets.*

Occasionally you may have some formulas in Excel that you wish to replace with values. You can of course manually replace the formula with the correct value – but if you have a large worksheet, this can be rather time consuming and leave you at risk of making errors! To prevent this and to speed up the process, you can replace formulas with values in Excel using an Excel function called Paste Values.

## Copy – Paste Values Selected Cells

Highlight the cells that contain the formulas that you wish to replace with values.

Then, in the **Ribbon**, select **Home > Clipboard > Copy. **

Then, in the **Ribbon**, select **Home > Clipboard > Paste > Paste Values.**

The formulas wll now be replaced with values.

Paste Values can also be found in Paste Special.

Instead of using Paste Values as described above, select **Paste Special** from the Paste drop down menu.

Then in the Paste Special Dialog box, select Values and click **OK.**

## Copy – Paste Values Entire Worksheet

To replace all the formulas in your entire worksheet with values, you can highlight the entire worksheet.

Click in the top left hand corner of your worksheet to select the entire worksheet.

Then, in the **Ribbon**, select **Home > Clipboard > Copy.**

Without clicking anywhere else, in the **Ribbon**, select **Home > Clipboard > Paste > Paste Values.**

NOTE: It may take a long time to paste the values if you have a large worksheet with lots of formulas.

## How to Replace Formulas With Values in Google Sheets

We can copy formulas and replace them with values in Google Sheets by using Paste Special.

Highlight the cells that contain the formulas you wish to replace.

Then, in the M**enu**, select **Edit > Copy** and then immediately select **Edit > Paste special > Values only.**

Your formulas will then be replaced with values.