| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing ref's within formulas without having to retype each one.
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing ref's within formulas without having to retype each one.
Use Edit Find/Replace and specify within formulas
-- Gary''s Student - gsnu200764 "Harley" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing ref's within formulas without having to retype each one.
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 "Harley" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing ref's within formulas without having to retype each one.
EditReplace should get you there.
Replace what: JAN! Replace with: FEB! Gord Dibben MS Excel MVP On Wed, 9 Jan 2008 11:41:01 -0800, Harley wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting duplicates with row ref's to a list | Excel Worksheet Functions | |||
| my Autocalc does not always work (Mirco 2003) I have to retype for | Excel Worksheet Functions | |||
| how do i manage without having to retype | Excel Discussion (Misc queries) | |||
| cells will not accept decimals.will not allow any retype with deci | Excel Worksheet Functions | |||
| Correct formulas in cells, have to retype to work | Excel Discussion (Misc queries) | |||
Linear Mode
