Categories
Excel Training

Remove cells from the Watch Window

  1. If the Watch Window toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) is not displayed, on the Formulas tab, in the Formula Auditing group, click Watch Window.
  2. Select the cells that you want to remove.

To select multiple cells, press CTRL and then click the cells.

  1. Click Delete Watch
Categories
Excel Training

Add cells to the Watch Window

  1. Select the cells that you want to watch.

To select all cells on a worksheet with formulas, on the Home tab, in the Editing group, click Find & Replace, click Go To Special, and then click Formulas.

  1. On the Formulas tab, in the Formula Auditing group, click Watch Window.
  1. Click Add Watch .
  2. Click Add.
  3. Move the Watch Window toolbar to the top, bottom, left, or right side of the window.
  4. To change the width of a column, drag the boundary on the right side of the column heading.
  5. To display the cell that an entry in Watch Window toolbar refers to, double-click the entry.

 Note   Cells that have external references (external reference: A reference to a cell or range on a sheet in another Excel workbook, or a reference to a defined name in another workbook.) to other workbooks are displayed in the Watch Window toolbar only when the other workbook is open.