1.4 & 1.5 Flashcards
Selecting with the Mouse/Selecting with the keyboard
column
Position the cell pointer on the column header (a letter) and then click the left mouse button.
row
Position the cell pointer on the row header (a number) and then click the left mouse button.
adjacent cells
Drag with the mouse into specific cells to select them.
nonadjacent cells
Press and hold down the Ctrl key while clicking the column header, row header, or specific cells.
all cells in worksheet
Click the Select All button.
cells in direction of arrow key
Shift + arrow key
from active cell to beginning of row
Shift + Home
from active cell to beginning of worksheet
Shift + Ctrl + Home
from active cell to last cell in worksheet containing data
Shift + Ctrl + End
entire column
Ctrl + spacebar
entire row
Shift + spacebar
cells containing data
Ctrl + A
groups of data separated by empty cells
Ctrl + Shift + spacebar