When using ExcelAnalyzer you will be jumping between the reports and the spreadsheet to perform the audit. There are some useful navigation shortcuts for ExcelAnalyzer which are actually Excel shortcuts and you can use them anywhere. If you don’t have a copy of ExcelAnalyzer yet, get a free trial copy of ExcelAnalyzer.
Shortcuts for moving backwards and forwards when using hyperlinks
ExcelAnalyzer makes use of hyperlinks to jump to the cells in the spreadsheet. There are buttons to go back to where you came from, but Excel itself has some shortcuts that, in some cases, are quicker to use and take you back to exactly the place you came from.
In Excel, if you jump to another sheet via a hyperlink or using the Auditing Toolbar, if you click F5 and then enter you will go back to exactly the cell you came from.
So if you click on F5 you will see the following, but it is not something you even have to look at. Just click Enter or click on the OK button and you will go straight back to the exact cell you came from. Makes it easier to jump between the spreadsheet errors reports and the spreadsheet to see if it is actually an error.
Alt + backwards or forwards arrow
A little know shortcut in Excel, useful even outside of ExcelAnalyzer, is the ability to go backwards and forwards based on recent hyperlinks clicked. Like your web browser, you can just go to the previous page you were on with the back arrow.
Excel allows you to do the same think if you click on
- ALT and the backwards arrow to go to the previous hyperlink (and if you do it again it takes you to the one previous to that), or
- ALT and forward arrow to go to the hyperlink you just came from.
Unhiding rows shortcuts
With the Formula Reports in ExcelAnalyzer, you often have hidden rows and depending where you have come from, you may end up on the Formula Report, but can’t see the information as the rows are hidden. You can go through the process of unhiding/ ungrouping but there is a risk that you forget what you were looking at.
So rather use Excel’s inbuilt shortcut for unhiding rows which is
CTRL + SHIFT + 9