I don’t use Excel full time, and I always for get how to select a large grid of data for pivot tables. I found a great reference over at Microsoft.
http://office.microsoft.com/en-us/excel/HA010548081033.aspx
| Press | To |
|---|---|
| CTRL+A | Select the entire worksheet |
| CTRL+SPACEBAR | Select the entire column |
| SHIFT+SPACEBAR | Select the entire row |
| F8 | Turn on extending a selection by using the arrow keys |
| CTRL+SHIFT+END | Extend the selection to the last used cell on the worksheet (lower-right corner) |
| CTRL+SHIFT+HOME | Extend the selection to the beginning of the worksheet |
| CTRL+SHIFT+arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell |
| SHIFT+F8 | Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range |
Advertisement
