I'm looking for a quick way to determine if there are any formulas at all present in an excel document.
Reason for asking is I send out a lot of customer pricing and I need to eliminate any formulas present so I don't reveal our profit margin or upcharge.
Last edited by PatSabre12; 11-18-2011 at 09:58 AM.
Do a CTRL+G click Special, select Formulas and click Ok
Repeat for each sheet...
Forrmula cells will be selected
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
THANKS! You've made my life a lot easier.
We were marking up some of our work by 20% (multiplying our numbers by 1.2) and we left a formula in, our customer called up and ripped us a new one saying that our markup was too high.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks