I have several formulas which i realize have a bad cell reference in them now. Is there any way to select a range of cells and then "Find and replace" that cell reference within the function?
I have several formulas which i realize have a bad cell reference in them now. Is there any way to select a range of cells and then "Find and replace" that cell reference within the function?
Hi Adam,
You should be able to select the cells, open the Find/Replace dialog and then click on the Options button to expand the dialog window. Make sure the 'LookIn' drop-down box is set to formulas.
You can then replace something like $F$7 with another cell reference, e.g. C5, G$8, etc.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks