Excel 2019 Bible

71

C H A P T E R

4

Working with Excel Ranges

and Tables

IN THIS CHAPTER

Understanding Excel cells and ranges

Selecting cells and ranges

Copying or moving ranges

Using names to work with ranges

Adding comments to cells

Working with Tables

M

ost of the work you do in Excel involves cells and ranges. Understanding how best to

manipulate cells and ranges will save you time and effort. This chapter discusses a variety

of techniques that are essential for Excel users.

Understanding Cells and Ranges

A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is

identified by its address, which consists of its column letter and row number. For example, cell D9 is

the cell in the fourth column and the ninth row.

A group of one or more cells is called a range. You designate a range address by specifying its upper-

left cell address and its lower-right cell address, separated by a colon.

Here are some examples of range addresses:

C24 A range that consists of a single cell.

A1:B1 Two cells that occupy one row and two columns.

A1: A10 0 100 cells in column A.

A1:D 4 16 cells (four rows by four columns).

C1:C1048576 An entire column of cells; this range also can be expressed as C:C.

A6:XFD6 An entire row of cells; this range also can be expressed as 6:6.

A1: X FD10 4 8 576 All cells in a worksheet. This range also can be expressed as either A:XFD or

1:10 4 8 576.

Excel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.