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
 

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

Similar Threads

Can you change letter case without having to retype words? 4
Printing a worksheet with and without formulas showing 1
Moving cells without changing the formulas 1
Adjusting formula for month in vlookup? 3
Excel 2003 - Linking Formulas, Worksheet to Worksheet 4
What do I use to reference the same cell in multiple formulas 2
Fill Data across multiple Worksheets - Formulas 1
Paste Formulas without new References 4

Top