Named cells in a formula

M

Marian

Hi, I have a problem with names in formulas.

In Sheet1!A1 I refered to the Sheet2, for example
"=Sheet2!A2+Sheet2!A3+Sheet2!A4". Later I named these three cells in
Sheet2 (Mortgage, Insuarance, Heating), so in Sheet1!A1 I expected the
formula like "Mortgage+Insuarance+Heating", but it does not change
automatically.
This is just little example of refering in my Workbook, so it would take
a long time, if I created formulas again, although with names.

Is there any quick way, how to change these addresses in formulas to names?

Thanx

Marian
 
D

Debra Dalgleish

For names on the same sheet as the formula, you can select a range of
cells, and choose Insert>Name>Apply. Select one or more range names, and
click OK.

For names that are on a different sheet, you can use Edit>Replace. For
example, Find what: Sheet2!A3 With:Insurance and click Replace All.
 
Top