Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi.
I have a worksheet where I want to show only some of the formulas used in it. That is why, instead of using the option "Show formulas" from the formulas Tab, I insert a ' before the = in the cells I want to see the formula. But when I want to show results once again, in order no to look for each formula in which I added the ', I use the Find and Replace Option. In Find I specify '= and leave in blank the Replace option. But Excel shows me the following message: "Excel cannot find the data you are searching for". Cannot figure out the correct way of doing it... Thanks in advance for your help Regards, Emece.- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Dissabling Error when editing formula with Find+Replace | Excel Worksheet Functions | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Find and replace error | Excel Worksheet Functions |