Microsoft Excel 2007 - Using the Ctrl-key
Click on the video icon for a demonstration
Quick Navigation
Press Ctrl and then any arrow key to move to the last populated cell in that direction.
Fast Selection
Press Ctrl+Shift and any arrow key to select all cells between the current and last populated cell in that direction.
Noncontiguous selections
Select any number of cells regardless of their location in the spreadsheet.
Press and hold the Ctrl key while you click on the cells.
-Or-
Press and hold the Ctrl key while dragging through a range of cells and then click on each additional cell.
Bonus
You may also use this tip to analyze any range or combination of individual cells with Excel's AutoCalculate feature.
Select the cells and then right-click on Excel's status bar. Choose the desired function to see the results (Sum, Avg, Max, Min, etc.).