Pressing F5, or Ctrl + g, opens the 'Go to' dialog box.

Using the 'Go to' feature has a number of advantages. The first is you can press F5 followed by Enter to return after following a hyperlink. This also works if you have turned off editing in a cell and have double clicked a cell to follow a link.

The 'Special' button in the 'Go to' dialog box opens another dialog that allows you select a whole range of different cell types in one action, for example select all the formulae in a sheet, which allows you to format them a special colour to identify them as formula.

Neale Blackwood is a senior business analyst with Access Analytic Solutions, which provides financial modelling, management reporting services, as well as advanced Excel training. You can email Neale at nblackwood@accessanalytic.com.au