O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

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

As you will see, there are many ways beyond a simple click-and-drag to isolate the particular types of data, formats, objects, and even blank cells that you need to gather or edit. Here are a few pertinent facts and definitions to start with:

  • While a region is defined as a rectangular block of filled cells, a range is any rectangle of cells, filled or empty.

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

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

  • You can select ranges of cells, but only one cell can be active at a time. The active cell always starts in the upper-left corner of the range, but you can move it without changing ...

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