![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com