You’ll find it under the Formulas tab, in the Formula Auditing group. Once you open it, just hit Add Watch and select the cells you want to monitor. The pop-up will show you the sheet name, cell ...

To do that, select the Data tab, highlight the table, and click From Table/Range in the Get & Transform Data command group of ...