Working with Range Names


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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.