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 TOTW index Next post 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.