Microsoft Office Tutorials and References
In Depth Information
Learning Selection Techniques
To select non-contiguous cells, click the
first cell, hold down the Ctrl key and
click each additional cell you want to
select. Figure 8-10 shows the non-contigu-
ous cells A3, A13, D1, and D4 through D12
selected. When making non-contiguous cell
selections, you can include entire rows and
entire columns along with individual cells or
groups of cells.
If you are inputting data, you can save time by
leaving your hands on the keyboard, so Excel also
provides ways you can make many selections with
your keyboard, instead of the mouse. Here are a
few of the methods you can use:
Select a contiguous range by using an arrow
key to move to the beginning of the range
you want and then hold the Shift key while
you arrow-key to the last cell of the range.
Select an entire column by pressing
Select multiple adjacent columns by first
selecting a cell in each column and then
Select an entire row by pressing
Select multiple adjacent rows by first
selecting a cell in each row and then pressing
Select all data filled cells adjacent to the
current cell by pressing Ctrl+Shift+* (asterisk).
(See Figure 8-11.) The current cell does not
have to be at the beginning of the range.
Selected non-contiguous cells.
To select the entire worksheet, press Ctrl+A
or click the small gray box located to the
left of column A and above row 1.
Click any single cell to clear the selection.
Selected contiguous cells with data.