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 ... Click on Sheet 2, then Right-click the cell where ...