Show All

Hide All

This is also called a 3-D reference (3-D reference: A reference to a range that spans two or more worksheets in a workbook.).

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.

• Q: Named range based on cell value?
• In Excel how do I delete or change the name of a range of cells?
• Are there any shortcuts to typing range names?
• Is it possible to change a Sheet reference in a formula?
• Nesting a sheet name reference within a cell reference???