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 www.AuditExcel.co.za Live Excel Training page