| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find formula used when spreadsheet has been cut / pasted?
I have a spreadsheet which has been cut and pasted to hide formulas. I have
been told there is a way to reveal the formulas used, is there? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find formula used when spreadsheet has been cut / pasted?
If it is the values that have been pasted, then you can't get at the
original formula. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "flossie lost it" <flossie lost wrote in message ... I have a spreadsheet which has been cut and pasted to hide formulas. I have been told there is a way to reveal the formulas used, is there? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find formula used when spreadsheet has been cut / pasted?
if it is copy and paste special values, you probably can't
you can try edit-goto-special-formulas you can try tools-formula audting-trace dependants "flossie lost it" wrote: I have a spreadsheet which has been cut and pasted to hide formulas. I have been told there is a way to reveal the formulas used, is there? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A pasted formula won't calculate? | Excel Worksheet Functions | |||
| copy active cell value,find the pasted value in different worksheet | Excel Worksheet Functions | |||
| Excel find/replace should allow values to be pasted in. | Excel Worksheet Functions | |||
| Need formula to find and sum values in a different spreadsheet | Excel Worksheet Functions | |||
| Can I retain a formula in the cell pasted to? | Excel Worksheet Functions | |||
Linear Mode
