How Do I Use the Watch Function?
Well, let's go through the steps that you'll need to use to turn it on and put it to use for you. First, find the Formula Auditing Tool bar. Here is where you'll find it: head to the Main Menu and into the View drop down menu. Once you are in the View menu, you simply click on Tool bars and then click on Formula Auditing. Once you click on Formula Auditing, you'll see a little tool bar pop up on your screen, and you can drag it wherever you like it.
Now that you have your tool bar up and running, find and click on the little button that has a pair of binoculars on it. This will open up the watch function window. Now, you will click on the “Add Watch" button, which should be the only thing that you can click on, and another window will pop up that is titled “Add Watch". You'll then go to your spreadsheet and highlight the cell(s) that you want to watch while you work on the rest of the document, and then click “Add". This doesn't always work across spreadsheets, so if you need to keep an eye on a cell in another workbook, you may have to create a cell in your current workbook that will continue to calculate the cell that you need to watch.
Once you have added that range or cell to your “Add Watch" list, it will return you to the Watch Window. If you need to watch several cells across your spreadsheet, you can add more watches to this list as well so that you can keep an eye on them all with ease. Simply follow the steps that you took to add the first watch to your sheet in the previous paragraph. And that is all there is to using the watch function in Microsoft Excel. When you are done, you can simply click the “X" and close out the “Watch Window".
Sound easy? It really is. And, it will help you keep track of long spreadsheets that can easily get jumbled up with numbers and formulas.