Navigation in Excel 2007
Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell, but you can change this behavior to move it up, down, left, right and even stay on.
Sometimes, you may want to view two different parts of a worksheet simultaneously - perhaps to make it easier to reference a distant cell in a formula. Or you may want to examine more than one sheet in the same workbook simultaneously.
If you need to select all objects embedded into the worksheet, e.g. select all charts to adjust their size, press Ctrl+G and click the Special button or use Ctrl to select objects individually.