Is there an easier way to navigate around large Excel data?

Jan 30, 2020 | Excel Hints and Tips

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:

  • Blanks
  • Current region
  • Current Array
  • Objects
  • 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.

Want to learn more about Excel? Then email to discuss how I can help or have a look at the Excel Courses I run.