Here we have some useful keyboard shortcuts that can help you for editing and finding errors in your model. First up we have alt MP and ALT MD these help you look for precedent cells and dependent cells. So if you imagine I have a formula in A7 if I did alt MP. That woudl create blue arrows that would show me the cells that are being drawn into the one in a seven. So maybe my formula in a seven is a formula multiplying A1 times A2 and it will show me two lines going to A1 and A2. Trace the pendants shows me future cells which are relied on a 7, so if I had a formula in a 10 link to A7 if I was in a Seven and did alt MD it would draw a line to A10. Alt M A gets rid of all those arrows you end up with blue arrows absolutely everywhere. Alt MK gets your error checking in particular Alt MKC allows you to investigate circular references. If you've got intentional circular references, it's great to check that they're correct, and if you unintentional circulars great way to try and investigate how they've come about.

Alt MH converts all of your formulas instead of showing the numbers that come out of the formula, it converts them back to actual formulas. So just looking at your screen you can see all of the formulas. It toggles on off so alt MH. Turn it on alt MH to turn it off again.

If you're looking at one particular cell, if you press f2 on your keyboard, then that shows your component sells it highlights those cells that are being included in your formula. So if you're formula is equals A1 + A2 + A3 if you press f2 on that formula, it will highlight those three cells. Control open square bracket jumps you to the first variable if the formula is cross tab. Imagine you're an output tab and you're trying to multiply two cells together ones on an input tab one's on a calculations tab. If you press Ctrl open square bracket, it would jump you to the first of those in your formula. If the input cell was the first one in your formula it would jump to that one. If you press Ctrl open square bracket and enter that jumps from variable to variable if the formula is all on the same tab, so if you've got A1 + A2 + A3, then press control open square bracket, then press enter enter and it'll cycle through those various items. Very handy, if you want to jump around your tab looking at the various variables. Lastly if you haven't jumping around a bit particularly with control open square brackets, if you press F5, and then enter it will take you back to the start back to the formula that you investigating.