Posted by TJ on Friday February 12, 2016 @ 03:01 PM
[Tags: excel, tips, accounting]

Below are some short cuts I use almost every day in Excel when auditing worksheets in excel. There are certainly more shortcuts than I discuss below but these are certainly less commonly discussed:

Ctrl + { Press these two keys together when you are in a cell with a formulated value and Excel will bring you to the sheet and cell it got linked from. If you go nowhere that likely means the cell does not contain a formula or there were too many variables.

Ctrl + } When you use this shortcut on a value Excel will bring you to the sheet and cell where the selected cell is being used in a formula. If you go nowhere that means the cell is not used in a formula or there are too many variables.

Ctrl + ~ When you use this shortcut you can switch displaying showing formulas or values on a sheet.