Microsoft KB Archive/47448

Globally Changing Formula-Referenced Cell or Range of Cells PSS ID Number: Q47448 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00

WINDOWS

Question:

Many formulas in my spreadsheet reference a single undefined cell or range of cells (a precedent). How can I globally change the cell, or range of cells, that the formulas (dependents) are referencing?

Response:

A cell referenced by multiple formulas can be changed globally in all dependent formulas by performing the following steps:


 * 1) Select and define the cell or range of cells being referenced (precedents). Define the selection as a name with Formula Define Name.
 * 2) Select the whole worksheet. Choose Formula Apply Names to search through the selected range and replace all references to the cell(s) with the name you’ve defined for that cell or range.
 * 3) Use Formula Define Name to then change the cell(s) referred to by the name you previously defined.

Copyright Microsoft Corporation 1993.