December 2006
Beginner
1080 pages
30h 43m
English
Content preview from Special Edition Using Microsoft® Office Excel® 2007Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 30. Using Names in Excel
In this chapter
Defining a Name for a Cell by Using the Name Box 842
Naming a Cell by Using the New Name Dialog 843
Using the Name Box for Quick Navigation 844
Using Scope to Allow Duplicate Names in a Workbook 845
Using Named Ranges to Simplify Formulas 846
Using a Name to Hold a Value 856
Assigning a Formula to a Name 857
Long before Microsoft introduced tables and formulas like =Revenue-Cost, spreadsheets have offered the ability to assign a name to a cell, to a range of cells, or to a formula. The theory is that using a name for a range would be easier to understand when used in a formula. =SUM(MyExpenses) would make formulas more self-documenting than =SUM(Sheet5!AB2:AB99).
With Excel 2007, ...