This article describes the cell positioning shortcut keys in Excel2007.
Tip: Use the Shift key in combination with the key combinations in the table below, you can select a range of cells, for example, pressing the Ctrl+shift+home key to select all cells from cell A1 to the current cell. To select the current range, the data region in which the active cell is located, press CTRL + Shift+*.
|cell positioning||shortcut key|
|a column where the current row is located||home|
|The first row of the data area (no empty cells in the data provided)||ctrl+ up Arrow|
|Last row in the data area (no empty cells in the supplied data)||The first column of the data area (no empty cells in the data provided)||last column in the data area (no empty cells in the supplied data)||ctrl+ right ARROW key|