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