Authored by Vince Russell on 26 July 2005 at 10:05AM
Current rating:
Filed under: Excel Tips

Removing formulas from Excel

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:
Filed under: Excel Tips