HOW TO CHANGE A FORMULA NAME IN A PAGE TO OTHER PAGE WITHOUT 1 BY.

N

nodoutt

I need to change the formula in the page in every link to a different page
in my work book. How can I do that with out having to fo it one by one in
each cell?
 
R

Roz

If I understand correctly, you have something that you need to change i
a bunch of different cells to a different formula? If so, this is
little quicker but it won't do them all at once (I'm not sure how to d
that). But if you change the formula in one cell, then highlight tha
cell, use format painter (the little paintbrush on your toolbar) an
highlight the new cell you wish to put the formula in. The only thin
is that it will completely change any formats you have in the othe
cell if they are different, so hopefully they are the same. I'm no
sure if this will work either, but I know in word, if you highligh
something and press either shift or control, you can highlight multipl
items. Try to use that to format paint all at once. Again, not sure i
it will work, but I hope so
 
P

Pete

You can use Edit | Replace (or CTRL-H). Highlight the cells you want
this to happen to, then CTRL-H, and in the find box enter:
worksheet_name!
and in the replace with box enter:
other_worksheet_name!
then click the Replace All button.

This assumes that you want to link to the same cells on the two
worksheets, just the worksheet name needs to change.

Pete
 
S

SteveG

You can change your Options to display all formulas in your sheet and
then use the Find Replace functionality. So say all of your formulas
in the sheet you want to change refer to a sheet with the name Sheet1!
to Sheet2!. Go to Tools/Options/View Tab. Under Window Options,
select the check box next to formulas. Click OK. When you go back to
the sheet, you will now see all of your formulas displayed. Go to
Edit/Replace. In the Find What? box, type the name of the old sheet
reference (Sheet1). In the Replace With type in the new sheet
reference (Sheet2). Select "Replace All". This will change all of
your formulas that contain a reference to Sheet1 to Sheet2. Go back
into the Tools/Options/View tab and deselect the checkbox next to
Formulas to hide your formulas from view in the worksheet.

HTH

Cheers,

Steve
 
N

nodoutt

Thanks to all that worked great, I figured it out while waiting for a
response, Thanks
 
Top