Watch window

When working with large worksheets in the Spreadsheet Editor, the Watch Window might come in handy to keep cells and their formulas in check. The Watch Window allows you to see changes in the cells that are not currently in the visible area of the worksheet. You can also quickly switch to the required cell with a double click in the Watch Window.

The Watch Window allows you to monitor the following watch parameters: Book, Sheet, Name, Cell, Value, and Formula.

To add a new watch,

1. Go to the Formula tab.
2. Click the Watch Window button.
3. Click the Add watch button in the Watch window.
4. Select the required data range to watch.
5. Click Close to return to the worksheet or continue working in the worksheet with an opened watch. All changes in the cells will be visible in the watch.

To delete a watch,

1. Go to the Formula tab.
2. Click the Watch Window button.
3. Select the required watch or several watches by clicking them via a button combination Ctrl+Left Mouse Button.
4. Click the Delete watch button and choose whether you want to Delete watch or Delete all.

Volver a la página anterior