Navigation in Excel 2013 2010 2007 2003

Useful Excel features to work with a lot of data

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.

How to select all the embedded charts on the worksheet

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.

Viewing a worksheet in multiple windows

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.

Changing moving direction of the cell pointer after entering data

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.