Working with multiple worksheets can be quite tough for Excel users, especially if there ... Click the Watch Window button in the Formula Auditing group. A Watch Window dialog box will open.