Control + [
• Do you ever want to find the source of a formula and see where it links to?
• Is it hard to follow cell references such as =Sheet2!B7?
Within a cell containing a reference to another cell – simply hold down the control key and at then press the square open bracket key
i.e. Control + [
This shortcut will take you up the dependency tree to the source of a formula.
Since I discovered this shortcut it has saved my tons of time and made my life far easier. Hopefully, you can now share the benefit.
Excel shortcuts can save you considerable time, especially when performing repetitive tasks.
A free comprehensive list of excel shortcuts
If you want a comprehensive list of excel shortcuts – fill in your details below and we’ll send them to you with our compliments.
Spreadsheet (excel) skills for Finance
On our spreadsheet courses we look at the most popular shortcuts and show you how to use them effectively. We like to say that you’ll at save the time spent learning at the very least.
Follow the link below for more information: