Easily Check Microsoft Excel 2010 Formulas

Many times with Excel Spreadsheets we are double and triple checking our data and formulas.  For me, sometimes it’s easier to get a visual picture when checking my formulas.  To do this, simply select the cell that contains your formula then press CTRL+ [ (open square bracket key). This will high light all the cells that are contained in that formula, so you can easily see them without having to scan through them using cell references.  You can also press the Enter key to scroll through all your referenced cells.