O'Reilly logo

2007 Microsoft® Office System Inside Out by Microsoft Corporation

Stay ahead with the world's most comprehensive technology and business learning platform.

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

Start Free Trial

No credit card required

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

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

Start Free Trial

No credit card required