Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Selecting Efficiently in Excel
FIGURE 2.2 Selecting a Region without Dragging
FIGURE 2.3 Use CTRL þ Shift þ *( þ A in Mac) for Selecting a Region
Any part of the region can be highlighted (selected) by first selecting a cell, a row,
or a column in a region and then by using CTRL
þ
Shift
þ’
, CTRL
þ
Shift
þm
,oras
shown above CTRL
þ
Shift
þ-
, and CTRL
þ
Shift
þk
, to extend the selection to the
end of that region in the direction we wish. CTRL
)
will enable selection from the starting cell(s) until the end of the data range in the
direction of the arrow. Use instead of CTRL for the Mac.
With larger spreadsheets, you may want to go back to the beginning of the sheet
or to the end of the data on the sheet. To go back to cell A1, press CTRL
þ
Shift
þ
any arrow key (
km-’
þ
Home; to
reach the last cell of the sheet use CTRL
þ
End.
End to select the data from the current cell to the last
active cell on the sheet. To go to the first cell of a row, press the Home key.
Also, try CTRL
þ
Shift
þ
Search JabSto ::




Custom Search