The Watch Window can be moved or parked wherever you like in your Microsoft Excel workbook.
If you close it, those cells will disappear from the Watch Window. For example, if you’re using Workbook A and have cells from Workbook B in the Watch Window, you must keep Workbook B open.
The exception is when you’re using multiple workbooks.
#HOW TO USE MICROSOFT EXCEL FOR WAREHOUSING HOW TO#
RELATED: How to Change the Cell Reference Style in ExcelĪny cells that you add to the Watch Window will remain there until you remove them (as seen below). If you need to see the result of a formula (value), you don’t have to scroll through your current sheet, move to a different one, or even pull another workbook into view. This is when the Watch Window becomes so valuable in large spreadsheets. Use the Watch WindowĪfter you add cells to the Watch Window, you can see the workbook name, sheet name, cell name, cell reference, value, and formula for each one. From there, follow the same steps as those listed above to open the Watch Window and add those cells. This selects all cells containing formulas in your spreadsheet. With your sheet active, go to the Home tab.Ĭlick the “Find & Select” drop-down box in the Editing section of the ribbon and select “Formulas.” If you prefer to add all cells containing formulas in your sheet, this is just as simple. Now, click “Watch Window” in the Formula Auditing section of the ribbon.Ĭlick “Add Watch” in the Watch Window toolbar.Ĭonfirm the cells that you’ve selected in the Add Watch pop-up window and hit “Add.” To add specific cells, first, select them, and then open the Formulas tab.
You can easily add cells to the Watch Window in your current spreadsheet, and you can select the particular cells containing formulas if you want to watch or view all the formulas in the sheet. You can view cells in your current workbook or another that you have open, which gives you the flexibility you need to stay on top of things. Tired of scrolling to see formulas and results in cells that aren’t in view? With the Watch Window in Microsoft Excel, you can keep an eye on your formulas without constant spreadsheet scrolling.Īvailable for all desktop versions of Excel, the Watch Window is a handy tool for seeing your formulas with their locations and results.
0 kommentar(er)
