Authored by Vince Russell on 26 July 2005 at 10:05AM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips

Removing formulas from Excel

Remove formula

I do like Microsoft Excel, I like it so much that I often create spreadsheets just for fun! I have spreadsheet to work out what temperature my tea will be after five minutes, formula to work out when and what my next CD purchase will be, even a spreadsheet to work out the frequency of my toilet visits per 500gram of Bombay mix eaten, broken down by day and hour.

However, when I email these spreadsheets to others, they are either too big for their email systems, too complicated for them to do anything with, or they didn't want them in the first place and are advising me that my tea is currently 12 degrees centigrade (duh! I know, I have got that spreadsheet!)

Help is at hand though, one thing I can do is to remove the formulas from Excel, and it's not a difficult thing to do.

  1. In Excel, select the cells you wish to remove the formula from
  2. Choose Edit | Copy from the main menu
  3. Then choose Edit | Paste Special… from the main menu
  4. In the dialog box that appears, choose Values from the options at the top and press ok

And that's it!

One other thing I could do I guess is to stop emailing people about how hot my tea is! After emailing them the first time, I only end up emailing them again to tell them it just changed!

Authored by Vince Russell on 26 July 2005 at 10:05AM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips

Comments about "Removing formulas from Excel"

Jason said

How do you do this for Excel 2007?

25 May 2009 at 10:53PM

Vince said

On the home tab on the menu ribbon, there's a big Paste button on the left hand side, under this there's a down arrow, click that and in the menu that appears, just choose Paste Values and hey presto, all done!!

26 May 2009 at 08:55AM

Ryden said

Paste special is not always available.

For one cell you can select, press F2 and then F9 and Enter

10 January 2012 at 03:26PM


Comment on this article

  

  


Remember Me?