Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit formulas on a worksheet simultaneously?
Excell question:
I have hundreds of formula links on one worksheet linking to a second worksheet. Every cell formula starts with 'worksheet 2' and then the cell reference. Is it possible to change, simultaneously, all these formulas to on the first worksheet to 'worksheet 3'...and leaving the cell references the same?? ewb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit formulas on a worksheet simultaneously?
Edit|Replace
Worksheet 2 Replace with Worksheet 3 Mike "ewb" wrote: Excell question: I have hundreds of formula links on one worksheet linking to a second worksheet. Every cell formula starts with 'worksheet 2' and then the cell reference. Is it possible to change, simultaneously, all these formulas to on the first worksheet to 'worksheet 3'...and leaving the cell references the same?? ewb |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit formulas on a worksheet simultaneously?
Sat, 16 Feb 2008 05:50:03 -0800 from ewb
: Excell question: I have hundreds of formula links on one worksheet linking to a second worksheet. Every cell formula starts with 'worksheet 2' and then the cell reference. Is it possible to change, simultaneously, all these formulas to on the first worksheet to 'worksheet 3'...and leaving the cell references the same?? Edit | Replace Select the Options button on the dialog because you may need to change some of the hidden options. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com A: Maybe because some people are too annoyed by top posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top posting such a bad thing? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit formulas on a worksheet simultaneously?
Have you given EditReplace a try?
If not, why not? If so, what happened? Gord Dibben MS Excel MVP On Sat, 16 Feb 2008 05:50:03 -0800, ewb wrote: Excell question: I have hundreds of formula links on one worksheet linking to a second worksheet. Every cell formula starts with 'worksheet 2' and then the cell reference. Is it possible to change, simultaneously, all these formulas to on the first worksheet to 'worksheet 3'...and leaving the cell references the same?? ewb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some more help to edit some formulas | Excel Worksheet Functions | |||
Edit Paste Special Formulas | Excel Worksheet Functions | |||
hide formulas but can edit on the same cells | Charts and Charting in Excel | |||
Edit multiple charts simultaneously | Excel Discussion (Misc queries) | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions |