Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Selecting Efficiently in Excel
ciently in Excel
Dragging the mouse is probably not the most efficient way of selecting a range in
Excel. If you select a small range, it may be more effective to hold the Shift key
down and use the arrow keys to select the range. In many instances, you have to
select large ranges of data. This chapter will describe a number of techniques to select
this data in a more efficient way.
Selecting an Entire Sheet. To select an entire sheet, either click on an empty
cell and use CTRL
A, or click on the small cell between column A and row 1. See
Selecting a Section. To select any continuous data or section, click on the first cell
of the section, then press Shift and click on the last cell of the section. You can also
reverse the process, click on the last cell, then press Shift and click on the first cell of
this section to select, keeping the Shift key pressed down. See Figure 2.2.
Selection Shortcuts. To select the current region in Excel, click on any cell in the
region and use CTRL
A in Mac). See Figure 2.3.
You can select an area from a currently highlighted cell or cells to the end of the
data in that region
* (star/asterisk) (
s column. Select the cell or cells and press CTRL
for the Mac). See Figure 2.4.
Using the same concept, you can select an area from a starting cell (or cells)
to the end of the data on that region
s row. You select the cell(s) and click
(right arrow). See Figure 2.5.
FIGURE 2.1 The Select All Button