有时,应用程序中的一项出色功能永远不会得到应有的认可,而 Excel 中的监视窗口(Excel)就是(Watch Window)此类功能的一个很好的例子。
如果您经常使用 Excel,您可能已经处理过一些非常大的工作表,这些工作表跨越数百行,如果不是数千行的话。如果您需要经常监控的某些单元格可以显示在单独的窗口中,这样您就可以一目了然地看到当前值和公式,这可能会很有用。(value and formula)Microsoft正是为此目的创建了Excel 监视窗口。(Excel Watch Window)
使用 Excel 监视窗口
使用Watch Window,您可以将重要的单元格拉出到一个单独的窗口中并在那里跟踪它们,这样您就不必滚动整个工作表。
让我们看一下下面的例子。假设这些数据是更大数据集(data set)的一部分,我们想要监控一些经常变化的重要单元格。
单击功能区上的“(Ribbon)公式(Formulas)”选项卡,然后在“公式审核(Formula Auditing)”部分下找到标题为“监视窗口(Watch Window)”的按钮。
这将打开监视窗口(Watch Window) 对话框(dialog box)。当然,该框是空的,因为我们还没有添加任何要监视的单元格。
现在让我们在监视窗口(watch window)中添加一个单元格。为此,请单击位于对话框(dialog box)顶部的Add Watch链接。
在“添加观察(Add Watch) ”对话框中(dialogue box),您可以通过以下两种方式之一选择单元格。您可以直接键入单元格引用(cell reference),也可以用鼠标选择单元格。当您只有一个或两个要监视的单元格时,直接键入单元格很有用。
但是,您不限于一次仅选择一个或几个单元格。您可以通过单击并拖动鼠标选择一系列单元格来将连续单元格添加到监视窗口。(Watch Window)完成后,单击“添加(Add)”按钮。
将单元格添加到Watch Window(Watch Window)后,您会注意到一些事情。首先,Excel已经开始监控单元格。对该单元格的值或公式(value or formula)的任何更改都将立即显示在Watch Window中。
其次,监视窗口(Watch Window)还会向您报告有关单元格的其他重要信息,包括单元格所在的工作簿和工作表以及单元格的名称(如果您给它的话)。(workbook and worksheet)
如果您愿意,您甚至可以将监视窗口拖到(Watch Window)Excel的一侧以停靠它,这样它就不会占用浮动工作表上的宝贵空间。
您可以从同一个 Excel 工作簿(Excel workbook)中的其他工作表中添加单元格,但不能从另一个工作簿中添加单元格。每个工作簿都有自己单独的Watch Window。如果您使用大型电子表格,Watch Window可以实时节省时间(time saver),并且可以通过让您将更多时间花在工作上而减少在Excel中点击的时间来提高您的工作效率。如果您有任何问题,请随时发表评论。享受!
此外,请务必查看我的其他Excel文章,您可以在其中学习过滤数据、将Excel 电子表格(Excel spreadsheet)插入Word、打开多个Excel实例、跟踪 Excel 中的更改以及(Excel)减去Excel中的日期。
Use the Excel Watch Window to Monitor Important Cells in a Workbook
Sometimеs a great feature in an application never gets the recognition it deservеs and the Watch Windоw іn Excel is a great example of оne sυch feature.
If you use Excel regularly, you probably have worked on some very large worksheets that span hundreds, if not thousands of rows. It could be useful if some of the cells you need to monitor often could be displayed in a separate window so that you could see the current value and formula at a glance. Microsoft created the Excel Watch Window for that exact purpose.
Using the Excel Watch Window
Using the Watch Window, you can pull out important cells into a separate window and keep track of them there, which saves you from having to scroll all over your worksheet.
Let’s take a look at the example below. Let’s say this data is part of a much bigger data set and we want to monitor a few important cells that change quite often.
Click on the Formulas tab on the Ribbon and locate the button titled Watch Window under the Formula Auditing section.
This will open up the Watch Window dialog box. The box, of course, is empty since we haven’t added any cells yet to monitor.
Now let’s add a cell to the watch window. To do this, click on the Add Watch link located at the top of the dialog box.
In the Add Watch dialogue box, you can choose cells in one of two ways. You can either type the cell reference in directly or you can select the cells with your mouse. Typing in the cells directly is useful when you have only one or two cells you want to monitor.
However, you are not limited to selecting only one or a few cells at a time. You can add contiguous cells to the Watch Window by clicking and dragging your mouse to select a series of cells. When you are done, click on the Add button.
You’ll notice a few things after you add the cell(s) to the Watch Window. Firstly, Excel has started monitoring the cells. Any changes to the value or formula for that cell will immediately show up in the Watch Window.
Secondly, the Watch Window also reports other important information to you about cells, including the workbook and worksheet in which the cells reside and the name of the cell, if you gave it one.
If you prefer, you can even drag the Watch Window to one of the sides of Excel to dock it so that it doesn’t take up valuable space on the worksheet floating around.
You can add cells from other worksheets within the same Excel workbook, but you can’t add cells from another workbook. Each workbook has its own separate Watch Window. If you work with large spreadsheets, Watch Window is a real time saver and is likely to increase your productivity by allowing you to spend more time on your work and less time clicking around in Excel. If you have any questions, feel free to comment. Enjoy!
Also, make sure to check out my other Excel articles where you can learn to filter data, insert an Excel spreadsheet into Word, open multiple instances of Excel, track changes in Excel and subtract dates in Excel.