To select a range of cells with the mouse, you simply click and drag. (To select a single cell, simply click it.) Alternatively, click to select the first cell , hold down [Shift] , and then click the last cell to select the range in between. You can also select cells, rows, and columns with the keyboard by using the following keyboard shortcuts.
[Shift] - [ ] , [Shift] - [ ’ ] , [Shift] - [ ‘ ] , [Shift] - [ “ ]
Hold down [Shift] and use the arrow keys to extend the selection by as many rows and columns as necessary.
[Ctrl] - [Spacebar]
[Shift] - [Spacebar]
[Ctrl] - [A]
[Shift] - [Backspace]
If the active cell is off the screen, Excel scrolls the window so that the active cell is displayed. If multiple cells are selected, Excel reduces the selection to the active cell and scrolls the window so that the active cell is displayed.
[Ctrl] - [Shift] - [Spacebar]
[F8]
Press [F8] to turn on Extend mode, and then use the arrow keys and other navigation keys without [Shift] to select a range. Excel displays EXT on the status bar when Extend mode is on. Press [F8] again to turn off Extend mode.
[Shift] - [F8]
Turn on Add mode so that you can add another range of cells to the existing selection. Press [Shift] - [F8] , and then use the arrow keys and other navigation keys without [Shift] to select each further range as necessary. Excel displays ADD on the status bar when Add mode is on. Press [Shift] - [F8] again to turn off Add mode.
[Ctrl] - [Shift] - [ ] , [Ctrl] - [Shift] - [ ’ ] , [Ctrl] - [Shift] - [ ‘ ] , [Ctrl] - [Shift] - [ “ ]
The data area is a block of cells containing entries. The end of the data area is defined by a blank column at the left or right, and by a blank row at the top or bottom. Pressing [Ctrl] - [Shift] - ‘ and [Ctrl] - [Shift] - “ in this shortcut extends the selection to the first or last row in the data area. Pressing [Ctrl] - [Shift] - 1 and [Ctrl] - [Shift] - ’ extends the selection to the first or last column in the data area. For example, press [Ctrl] - [Shift] - ’ to extend the selection to the last column used in the data area for the row containing the active cell.
[Shift] - [Home]
[Ctrl] - [Shift] - [Home]
[Ctrl] - [Shift] - [End]
The last cell used is the last cell that has ever contained an entry. It may not currently contain an entry.
[End] , then [Shift] - [ ] , [Shift] - [ ’ ] , [Shift] - [ ‘ ] , [Shift] - [ “ ]
[End] , then [Shift] - [Home]
[End] , then [Shift] - [Enter]
[Shift] - [PageDown]
[Shift] - [PageUp]
[ScrollLock] , then [Shift] - [Home]
Depending on your keyboard, you may need to press [ScrollLock] again to switch it off after using this keyboard shortcut and the next .
[ScrollLock] , then [Shift] - [End]