Follow the steps below on how to switch between sheets using the Watch Window in Microsoft Excel: Click a cell in Sheet 1, then click the Formulas tab. Click the Watch Window button in the Formula ...