Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
save .xls w/o the formulas just the numbers
i have a .xls file that has been layed out very nicely (and i wasnt supposed
to change it), but the silly bugger who designed it, didnt put it the formulas to relate various cells where totaling stuff. i thought i had seen someway to save the .xls with only the 'results' of the calculations rather than w/ all the formulas in it i put in. was that a figment of my imagination? thanks. jim |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
save .xls w/o the formulas just the numbers
Jim, What you are after is a copy of the values rather than the formulae that sit behind the calculations. To do this is easy - Open the file and select all by clicking on any cell on the page and hitting ctrl-A, then copy the whole page with Ctrl-C and open up a new workbook (you can do this first if you like), next you are going to "paste special" into this new book. Click onto EDIT and select PASTE SPECIAL, there are several options here, but the one you are probably after is 1) FORMAT and 2) Values. The first option will recreate the file in the same format as the original (colours, boxes that sort of thing) the second option populates this sheet with the values without importing the formulae. Cheers Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=562091 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an excel file with values instead of formulas? | Excel Worksheet Functions | |||
Why won't my formulas work until I save the worksheet? | Excel Worksheet Functions | |||
How do I set up formulas with letters and numbers? | Excel Worksheet Functions | |||
Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions | |||
How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions |