Revealing Formulas in Excel

To view all formulas and functions quickly when using any version of Excel, hold down the Ctrl key followed by the accent key. This is normally the first key on the left of the top row of the keyboard (above the tab key). This will immediately display all formulas. A new toolbar will also appear called Formula Auditing. The first button on the left checks for errors and the next two along draw arrows to show where formulas take their information from. Use the same shortcut to return to normal view.