How do I save a copy of an excel file without the formulas?

G

Guest

I am trying to save a copy of an excel file with just the numbers that the
formula came up with - not the formulas themselves.
 
P

Peo Sjoblom

First do a save as and give it a name, then select all formulas by pressing
F5, special and formulas, then
do edit>copy, then edit>paste special as values

--

Regards,

Peo Sjoblom


"Saving Excel File without Formula" <Saving Excel File without
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Formulas displayed in cell rather than calculated values? 4
repost of question from 2/4 "Using drop-down lists" 2
Formulas to Numbers 2
Keeping Formulas Not Data 1
Array formulas 3
Array formulas not working in Excel 2003. 2
copy an exact formula without changing cell reference 1

Top