Understanding Selection

Knowing how to select cells, rows, and columns in Excel is fundamental to using the program to its fullest potential. As you will see, there are many more ways to use selection techniques to isolate particular types of data, formats, objects, and even blank cells. Even though some of this information may seem basic, you’ll probably encounter a few tips that will make your spreadsheet life a little easier:

  1. Before you can work with a cell or range, you must select it, and when you do, it becomes active.

  2. The reference of the active cell appears in the Name box at the left end of the formula bar.

  3. Only one cell can be active at a time, but you can select ranges of cells, and when you do, the active cell is in the upper-left corner ...

Get 2007 Microsoft® Office System Inside Out 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.