CHAPTER 2

Working with Range Names

image

You can make it easier to navigate Excel worksheets and build Excel formulas by applying names to your ranges. This chapter explains range names and shows you how to define, edit, and use range names.

Understanding the Benefits of Using Range Names

Define a Range Name

Using Worksheet Text to Define a Range Name

Navigate a Workbook Using Range Names

Change a Range Name

Delete a Range Name

Paste a List of Range Names

Understanding the Benefits of Using Range Names

A range name is a text label that you apply to a single cell or to a range of cells. Once you have defined a name for a range, you can use that ...

Get Teach Yourself VISUALLY Excel 2016 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.