Excel Tip of the Week #83 - Revisiting navigation shortcuts

Hello all welcome back to the Excel Tip of the Week!  This week, we have a Basic User post, in which we look back at navigation shortcuts, originally covered way back in TOTW #5.

Moving within a workbook

Ctrl + arrow keys
Skips through an entire block of text at once (stops just before the first blank cell in the chosen direction)

Page Up / Page Down
Move the screen one “page” vertically

Alt + Page Up / Page Down
Move the screen one page horizontally

Ctrl + Page Up / Page Down
Scroll between different worksheets within the current workbook

Shift + any shortcut shown above
Select all the cells /sheets moved through

Alt + Tab
Toggle between two most recently used windows (press Tab multiple times to select an older window)

Selection shortcuts

Ctrl + [
(if pressed when highlighting a formula cell) Highlight all inputs (“Precedents”) for the current formula

Ctrl + ]
Highlights all cells which use the current cell’s value in some way (“Dependants”)

Find & Select menu

This menu lets you select all cells that meet a certain criteria.  There are a few presets for more common options which you can see in the middle section: Select Formulas, Comments, Conditional Formatting, Constants, or cells with Data Validation.  Pressing those options will instantly select all cells on the current worksheet with those qualities.

The “Go To…” button will let you select a worksheet and cell address and travel instantly to that location.

“Go To Special” opens a menu which lets you customise which cells you want to select.  You can mess around with options similar to the preset ones, but also things like blanks, visible cells, or all dependants (i.e. any cell which relies on either the current cell or on any cell reliant on it).

You can highlight a region before using Go To Special and it will only highlight matching cells from within that region.  This can be used for some clever things – e.g. you can highlight columns A and B and then use Go To Special => Row differences, and this will highlight any cell in column B with a different value to the corresponding cell in column A.

All of these options are useful tools in workbook reviewing and auditing.

Previous post - Useful macros and custom functions 
TOTW index
Next post - Scenario Manager

This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.