To make the inner workings of your spreadsheet more visible you can display ALL the formulas instead of their results with a simple shortcut. Press ctrl and ` - this will toggle between showing formula results and the formula itself.
Have you ever created a formula in excel and a few months later struggled to understand what it is doing? Well you can add notes within a formula to help with future understanding. This works by using the N function. See below for an example:
=1000 - 250 + N(”Wages minus bills”)
Instead of physically typing the dollar symbol into your cell reference when creating a formula, simply click on the part of the formula that you need the dollar symbols to be in and press F4 on your keyboard. If you continue to press F4 you will find that Excel will cycle through the different options for the dollar sign. E.g. $A$1 -> $A1 -> A$1 and back to A1.
This tip also works with refernces to other Excel Sheets or Workbooks.
VIDEO TIP BELOW
Microsoft Office Template Microsoft Office News Our Feed Please Use