Getting back to the original cell when using the Formula Auditing Toolbar

If you make regular use of the Formula Auditing Toolbar (as everyone should), you may find it difficult to get back to the original cell once you have followed a link to another sheet or spreadsheet. A simply solution exists. When you have followed the link, push the F5 key and then click ENTER (without touching anything else). It will take you straight back to the cell you started on.

Watch how to follow where the cells look on the  Excel fundamentals free course

Learn more at our live advanced Excel courses in South Africa. Visit Live Excel Training page

Double click Excel cell to follow formula not working

How to follow an Excel link to another sheet/ spreadsheet