Well here’s something I never knew until today…I was watching one of Mike ExcelIsFun Girvin’s great YouTube videos from his great Slaying Excel Dragons series – the one on Excel 2010 Keyboard Shortcuts – when he showed how to do the equivalent of a mouse right click using a key on the keyboard that I’d never noticed before…the Menu key.
The menu key is located to the right of the space-bar, tucked in between the Windows key and the right Ctrl key.
I wonder if even Dick Kusleika knows that one. (Legend has it that the only time that Dick’s fingers leave the keyboard is when he “salutes” Excel when it crashes.)
Hui pointed me to a recent post right here called Replace formulas with values using this shortcut that covers this very tip, but somehow I missed it.
Did you know about that key? Be honest now, in the comments below.
—Update—
Both Sam and Marton have reminded me that if you don’t have the menu key, you can instead use Shift+F10 to do the same thing. Thanks, chaps…without you, I’m half-baked!
One Response to “Loan Amortization Schedule in Excel – FREE Template”
The balance formula as given doesnt seem to work on my excel