Microsoft Office Tutorials and References
In Depth Information
Making Selections with the Keyboard
3. Ifyouwant to selectmore thanonecell,use thearrowkeys toextendyour
If you just want to select the currently active cell, do nothing; you’re ready to go
onto the next step. When you want to add a whole block of cells, you can mark
out your selection now. Remember, at this point you’re still selecting a
continuous range. In the steps that follow, you can add several distinct continuous
ranges to make a noncontiguous selection.
When you hit Shift+F8, you switch to add mode, and you see the text “Add to
Selection” appear in the status bar.
5. Younowhave twochoices:Youcanrepeat steps1 to4 toaddmorecells to
You can repeat steps 1 to 4 as many times as you need to add more groups
of cells to your noncontiguous range. These new cells (either individuals or
groups) don’t need to be near each other or in any way connected to the other
cells you’ve selected. If you change your mind and decide you don’t want to do
anything with your selection after all, press F8 twice—once to move back into
extend mode and then again to return to normal mode. Now, the next time you
press an arrow key, Excel releases the current selection.
Tip: You can also use the keyboard to activate AutoSelect. Just hold down the Shift key and use one of
the shortcut key combinations that automatically jumps over a range of cells. For example, when you hold
down Shift and then press Ctrl+ , you’ll automatically jump to the last occupied cell in the current row
with all the cells in between selected. For more information about the shortcut keys, refer to Table 14-1 on
poWer Users’ CliniC
Selecting Cells with the Go To Feature
In Chapter 14 (on page 359), you learned how you could
use the Go To feature to jump from one position in a cell to
another. A little known Excel secret also allows you to use
the Go To feature to select a range of cells.
the selection you want to highlight. Now, here’s the secret:
Hold down Shift when you click the OK button. This action
tells Excel to select the range of cells as it moves to the
It works like this: Start off at the top-left cell of the range
you want to select. Then, open the Go To window by
selecting Home➝Editing➝Find & Select➝Go To or
pressing Ctrl+G. Type in the address of the bottom-right cell in
For example, if you start in cell A1 and use the Go To
window to jump to B3, then you’ll select a block of six cells: A1,
A2, A3, B1, B2, and B3.