Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How find all formulas on tab?
Thanks in advance.
I have a request from my supervisor to make an Excel file value only. I can do that by copying and then paste special, values. But before I do that, I want to check if there are any cells in the tab that have formulas, and therefore "need" to be pasted special. Is there a way to get info on which cells are formulas? I know of the Trace Precedents and Trace Dependents buttons, but I don't know how to do for a whole worksheet at a time. Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am trying to find cotangent in the formulas. | Excel Discussion (Misc queries) | |||
Find Cells with Formulas | Excel Discussion (Misc queries) | |||
Find Cells that do not have Formulas in them. | Excel Worksheet Functions | |||
where can I find help with excel formulas? | Excel Discussion (Misc queries) | |||
I NEED TO FIND TWO FORMULAS | Excel Worksheet Functions |