Name cells on more than one worksheet

Microsoft Office Excel 2003

previous page next page

Show All Show All

Name cells on more than one worksheet

This is also called a 3-D reference.

  1. On the Insert menu, point to Name, and then click Define.
  2. In the Names in workbook box, type the name.
  3. If the Refers to box contains a reference, select the equal sign (=) and the reference and press BACKSPACE.
  4. In the Refers to box, type = (equal sign).
  5. Click the tab for the first worksheet to be referenced.
  6. Hold down SHIFT and click the tab for the last worksheet to be referenced.
  7. Select the cell or range of cells to be referenced.
previous page start next page