Navigation in Excel 2016
If you have a lot of data, manual editing and formatting of cells isn’t an option any more. However, Excel provides you many group operations that make those manipulations quick and easy.
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.
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.
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.