Add A Watch Window In Excel 2016

 admin

Select the Store button or the Manage add-ins button on your add-ins bar. On the Office add-ins page, you can do the following: Search for new add-ins. Use the options on the toolbar to add more add-ins, uninstall an add-in, or refresh the page to see a list of the latest add-ins. Turn an add-in on or off by sliding the toggle switch. Immediate, locals and watch windows won't open in vba editor for word or excel in Word 2016 Windows 10. On my newly acquired copy of Office 2016, when I open the VBA editor, I can see the code windows and project and properties windows and write and run code. However when I select View Immediate Window, Ctrl-G, View Locals Window, View Watch.

Watch
  1. Open a Watch window by selecting Debug Windows Watch Watch 1, or pressing Ctrl+Alt+W 1. You can open additional Watch windows by selecting windows 2, 3, or 4. In the Watch window, select an empty row, and type variable a. Do the same for b and c. Continue debugging by selecting Debug Step Into or pressing F11 as needed to advance.
  2. Excel 2016 has a variety of viewing options that change how your workbook is displayed. These views can be useful for various tasks, especially if you're planning to print the spreadsheet. To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.
  3. Microsoft has released another version of Office 2016 for Windows to be tested by insiders. This one is bought and installed from the Windows 10 Store. Naturally Office-Watch.com dived in to check it out. At the moment, only some Windows Insiders and users of Windows 10S can get Office in the Windows Store.

Lesson 25: Track Changes and Comments

/en/excel2016/conditional-formatting/content/

Introduction

Let's say someone asked you to proofread or collaborate on a workbook. If you had a printed copy, you might use a red pen to edit cell data, mark spelling errors, or add comments in the margins. Excel allows you to do all of these things electronically using the Track Changes and Comments features.

Alert! The Track Changes command has been removed from the Review Tab in Excel 2016.

Add A Watch Window In Excel 2016

Optional: Download our practice workbook.

Add A Watch Window In Excel 2016 Download

Watch the video below to learn more about track changes and comments.

Understanding Track Changes

When you turn on the Track Changes feature, every cell you edit will be highlighted with a unique border and indicator. Selecting a marked cell will show the details of the change. This allows you and other reviewers to see what's been changed before accepting the revisions permanently.

In the image below, each edited cell has a blue border and a small triangle in the upper-left corner.

There are some changes Excel cannot track. Before using this feature, you may want to review Microsoft's list of changes that Excel does not track or highlight.

You cannot use Track Changes if your workbook includes tables. To remove a table, select it, click the Design tab, then click Convert to Range.

To turn on Track Changes:

2016
  1. From the Review tab, click the Track Changes command, then select Highlight Changes from the drop-down menu.
  2. The Highlight Changes dialog box will appear. Check the box next to Track changes while editing. Verify that the box is checked for Highlight changes on screen, then click OK.
  3. If prompted, click OK to allow Excel to save your workbook.
  4. Track Changes will be turned on. A triangle and bordercolor will appear in any cell you edit. If there are multiple reviewers, each person will be assigned a different color.
  5. Select the edited cell to see a summary of the tracked changes. In our example below, we've changed the content of cell D14 from ? to Getting to know your team.

When you turn on Track Changes, your workbook will be shared automatically. Shared workbooks are designed to be stored where other users can access and edit the workbook at the same time, such as a network. However, you can also track changes in a local or personal copy, as seen throughout this lesson.

To list changes on a separate worksheet:

You can also view changes on a new worksheet, sometimes called the Tracked Changes history. The history lists everything in your worksheet that has been changed, including the old value (previous cell content) and the new value (current cell content).

Download
  1. Save your workbook.
  2. From the Review tab, click the Track Changes command, then select HighlightChanges from the drop-down menu.
  3. The Highlight Changes dialog box will appear. Check the box next to List changes on a new sheet, then click OK.
  4. The tracked changes will be listed on their own worksheet, called History.

To remove the History worksheet from your workbook, you can either save your workbook again or uncheck the box next to List changes on a new sheet in the HighlightChanges dialog box.

Reviewing changes

Tracked changes are really just suggested changes. To become permanent, the changes must be accepted. On the other hand, the original author may disagree with some of the tracked changes and choose to reject them.

To review tracked changes:

  1. From the Review tab, click Track Changes, then select Accept/Reject Changes from the drop-down menu.
  2. If prompted, click OK to save your workbook.
  3. A dialog box will appear. Make sure the box next to the When: field is checked and set to Not yet reviewed, then click OK.
  4. A dialog box will appear. Click Accept or Reject for each change in the workbook. Excel will move through each change automatically until you have reviewed them all.
  5. Even after accepting or rejecting changes, the tracked changes will still appear in your workbook. To remove them completely, you'll need to turn off Track Changes. From the Review tab, click Track Changes, then select Highlight Changes from the drop-down menu.
  6. A dialog box will appear. Uncheck the box next to Track changes while editing, then click OK.
  7. Click Yes to confirm that you want to turn off Track Changes and stop sharing your workbook.

To accept or reject all changes at once, click Accept All or Reject All in the Accept or Reject Changes dialog box.

Turning off Track Changes will remove any tracked changes in your workbook. You will not be able to view, accept, or reject changes; instead, all changes will be accepted automatically. Always review the changes in your worksheet before turning off Track Changes.

Comments

Sometimes you may want to add a comment to provide feedback instead of editing the contents of a cell. While often used in combination with Track Changes, you don't necessarily need to have Track Changes turned on to use comments.

To add a comment:

  1. Select the cell where you want the comment to appear. In our example, we'll select cell D17.
  2. From the Review tab, click the New Comment command.
  3. A comment box will appear. Type your comment, then click anywhere outside the box to close the comment.
  4. The comment will be added to the cell, represented by the red triangle in the top-right corner.
  5. Select the cell again to view the comment.

What Is Watch Window In Excel

To edit a comment:

  1. Select the cell containing the comment you want to edit.
  2. From the Review tab, click the Edit Comment command.
  3. The comment box will appear. Edit the comment as desired, then click anywhere outside the box to close the comment.

To show or hide comments:

  1. From the Review tab, click the Show All Comments command to view every comment in your worksheet at the same time.
  2. All comments in the worksheet will appear. Click the Show All Comments command again to hide them.

You can also choose to show and hide individual comments by selecting the desired cell and clicking the Show/Hide Comment command.

To delete a comment:

  1. Select the cell containing the comment you want to delete. In our example, we'll select cell E13.
  2. From the Review tab, click the Delete command in the Comments group.
  3. The comment will be deleted.

Add A Watch Window In Excel 2016 File

Challenge!

  1. Open our practice workbook.
  2. Turn on Track Changes.
  3. Replace the value in cell D14 with Rope Bridge Activity.
  4. Change cell E15 to say Julia.
  5. Save your workbook.
  6. List changes on a new sheet. After you do this, the worksheet should look like this:
  7. Return to the Agenda Planner tab.
  8. Add a comment to cell E16 that says snacks will be provided by the exec team.
  9. When you're finished, your workbook should look like this:
  10. Accept All Changes, then turn off Track Changes.
Add

Add A Watch Window In Excel 2016 Software

/en/excel2016/inspecting-and-protecting-workbooks/content/