Deleting a formula, but keeping the data

  • Thread starter Thread starter jenniedotkom
  • Start date Start date
J

jenniedotkom

Hi all...

this is my first time here, and I only have basic knowledge of Excel s
please bear with me!

This may be a VERY simple question, but I have looked and couldn't fin
the answer:

How do I delete the formula I used to come up with data, yet keep th
data ("un formula-ed")?! I assumed I could just delete the formul
from the formula bar, but it then deletes the data too.

Again, I'm sorry if there is an obvious answer to this, but I trul
tried everything I can think of!

Thanks for any help!

Jenni
 
I answered my own question by looking in the Tips section of thi
website! F2 , then F9 then CTRL + Enter and this works! (g
figure!)

Thanks anyways,
Jenni
 
Hi Jennie

Select the range
F5
Special
Select Formulas
OK

Edit>Copy
Edit>PasteSpecial
Select values
Ok
Esc
 
one way:

Copy the cell(s). Choose Edit/Paste Special. Select the Values radio
button and click OK.
 
Thanks everyone for answering me! This solution ended up being th
easiest way, so Thanks Frank!

I love learning new things! :)

Jennie

Frank said:
*Hi
copy the cell and goto 'Edit - Paste Special' and choose 'Values'
Click to expand...
[/QUOTE]
 
Back
Top