## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# Chapter 5. Working with Cells and Ranges

<feature><title>In This Chapter</title>
</feature>

Most 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 you can use to help increase your efficiency.

# 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 D12 is the cell in the fourth column and the twelfth row.

A group of 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:A100 100 cells in column A. A1:D4 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:XFD1048576 All cells in a worksheet.

## Selecting ranges

To perform an operation on a range of cells in a worksheet, you must first select the range. For example, if you want to make the text bold for a range of cells, you must ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required