Changing ref's within formulas without having to retype each one.

H

Harley

I need to change ref's (month's) within many formulas. Is there a shortcut to
help expidite this. For example, I have numerous formulas relating to each
month. I need to change all "JAN" refs to "FEB" refs for the appropriate
worksheet without having to retype each formula.

thanks,

Harley
 
C

CLR

Depending on how your formulas are structured, ou could just give a helper
cell the RangeName of JAN, and then just enter FEB in that cell..........

Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

Edit>Replace should get you there.

Replace what: JAN!

Replace with: FEB!


Gord Dibben MS Excel MVP
 
Top