formula update

F

fish

how do i update formulas in rows? without having to
update all of my formulas individually?
 
M

Myrna Larson

What are the formulas and whay do you want to change?

Did they get there by copying down? If so, modify the top formula and copy it
down.

If you want to change something like a column reference to a different
different column, you could use Search and Replace to replace, say A with C,
but you would have to be careful that the column letter doesn't occur within a
function name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top