Today I was working on an Excel workbook in which I had to ensure two columns of numbers always equaled each other. For a while I kept taking breaks, creating a quick SUM formula to see if they add up, and if they didn’t, go in and try to find where I messed up. All of a sudden it hit me, why had I forgotten a simple, yet great feature of Excel, the “Watch Window”? Simply put, the Watch Window is a little window that appears on top of your workbook, and displays cells you’ve selected. 

 In my situation, I set up a formula which always added up all the numbers in my two columns, and then set up a Watch Window. Now, as I input data, I can constantly make sure that each column is equal. Watch it here.

Empty ad slot (#1)!