Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

How to Remove Formulas in Excel

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

There are times when I have an Excel worksheet full of formulas and I want to hard code the results and remove the formulas completely.

This is very easy to do in Excel!

Here is our sample worksheet which has the following formulas in Column E:

I explain how you can remove formulas in Excel below:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Select all the cells that have formulas:

 

STEP 2: Right click and select Copy:

 

STEP 3: Right click again and select Paste Values:

Now you will see that the values are only retained and the formulas are now gone!

 

How to Remove Formulas in Excel

HELPFUL RESOURCE:

Searching... Searching...

DO YOU WANT TO GET BETTER AT EXCEL?
If so, join over 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis!

Click here to subscribe

Leave a Comment

Your email address will never be published. Required fields are marked with *

Comments