Excel has a number of shortcuts that work with a double click. Here's a few:

• Double click the AutoSum toolbar icon to automatically insert a SUM formula (it uses the guessed range). If you select a range first it only takes a single click to insert the SUM function.
• Double click a tab name to rename the sheet.
• Double click the lines between rows and columns to resize the rows / columns to fit the contents.
• Double clicking within the formula bar can select references and function names to enable you to change the 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