See all Microsoft Excel tips
Strategy: Microsoft added the Watch Window in Excel 2002. This window is a favorite tool of VBA programmers and Microsoft added it to the regular Excel interface.
1) From the menu, select Tools – Formula Auditing – Show Watch Window, as shown in Fig. 1247.
2) The Watch Window is a floating dialog box that you can move around your screen. Select Add Watch…, as shown in Fig. 1248.
3) Using the Add Watch dialog, navigate to and touch the cell that you want to watch. Alternatively, you can first navigate to the cell, select Add Watch and choose Add, as shown in Fig. 1249 For each cell that you Add to the Add Watch dialog, you can always see the formula and the result of that formula in the Watch window. You can add cells from other sheets and even other workbooks, as shown in Fig. 1250.
Summary: If you have Excel 2002 or a newer version, the Watch Window is a great tool for keeping an eye on far-off cells in your worksheet.
Commands Discussed: Tools – Formula Auditing – Add Watch
See all Microsoft Excel tips
