3. Working with Names

  1. John Walkenbach

Published Online: 1 NOV 2011

DOI: 10.1002/9781118257630.ch3

Excel® 2010 Formulas

Excel® 2010 Formulas

How to Cite

Walkenbach, J. (2010) Working with Names, in Excel® 2010 Formulas, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257630.ch3

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 10 MAY 2010

ISBN Information

Print ISBN: 9780470475362

Online ISBN: 9781118257630

SEARCH

Keywords:

  • names;
  • Excel;
  • workbook;
  • dialog box;
  • cell

Summary

This Chapter contains sections titled:

  • What's in a Name?

  • A Name's Scope

  • The Name Manager

  • Shortcuts for Creating Cell and Range Names

  • Creating Multisheet Names

  • Working with Range and Cell Names

  • How Excel Maintains Cell and Range Names

  • Potential Problems with Names

  • The Secret to Understanding Names

  • Advanced Techniques That Use Names