When you have a large document it can become tricky to move around but with a few special tools it can become a lot easier to navigate Excel.
Navigating to the top and bottom of the document
There are some great keyboard shortcuts that can help you with this.
CTRL + HOME returns you to the top of the document
CTRL + END takes you to the last row and column that contains something
If the END key is pressed then the ARROW key you are moved to just above the first blank cell in the direction of the arrow
Selecting all the cells
There is a handy shortcut to select all the cells in the current region by using CTRL + A.
Selecting specific cells
By selecting a cell, pressing the SHIFT key then selecting another cell a range can be chosen. If the CTRL key is used instead then non adjacent cells can be chosen instead.
In addition, if the SHIFT key is held down then the END key is pressed, then an ARROW key it selects in the direction of the arrow, stopping at the first blank cell. Note that the END Key and ARROW key are not held down together for this to work
Navigating to a specific cell
Set behind the Find and Select icon on the Home tab the option of Go to allows you to navigate to a specific cell or range of cells. In a long document this can be far more efficient than just scrolling.
Navigating to special cells
Also available from the Find and Select icon are the options of formulas, comments, conditional formatting, constants and data validation. These takes you to cells containing these specific types of information.
There are more options similar to this available from the Go To Special options under Find and Select. When finding constants or formulas the type of data can be restricted to numbers, text, logicals or errors. Conditional formats and data validation can be restricted to only those set up the same as the current cell if required. The other options available are:
- Current region
- Current Array
- Row or Column differences
- Precedent or dependents (either direct or all levels)
- Last cell
- Visible Cells
For precedents or dependents, current region and current array this is related to the specific cell that is currently selected.