Skip to Main Content
Teach Yourself VISUALLY Excel 2016
book

Teach Yourself VISUALLY Excel 2016

by Paul McFedries
October 2015
Beginner content levelBeginner
352 pages
9h 32m
English
Visual
Content preview from Teach Yourself VISUALLY Excel 2016

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 ...

Become 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,
and much more.
Start your free trial

You might also like

Excel 2010 Made Simple

Excel 2010 Made Simple

Abbott Katz

Publisher Resources

ISBN: 9781119074731Purchase book