HDTutorial
EN
How to Track Changes and Add Comments in Excel 2016

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Track Changes and Add Comments in Excel 2016

6,097 views October 26, 2016 1:39

Watch on YouTube
ChannelExcel, Word and PowerPoint Tutorials from Howtech

Description from the creator

In this HowTech tutorial, we’re going to show you how to track changes and add comments in Excel 2016.

Don't forget to check out our main channel youtube.com/c/HowTech for more free how-to videos!
Join us on Facebook
Facebook.com/howtechtv
Our App
bit.ly/how-tech


Open the dropdown Track Changes found under the Review tab and click Highlight Changes.

Fill in the necessary information according to your needs or leave it as the default and hit OK.

This will automatically save the workbook if you continue.

Now whenever you edit a cell, it will be emphasized and have a tooltip that pops up when hovered over.

To create a comment, select a range or a single cell and hit New Comment under the Review.

You can now add text to the comment.

To delete a comment, highlight the cell and hit Delete under the Review tab.

If you want to see all the comments, hit Show All Comments under the Review tab.

This is a HowTech tutorial, visit our website and watch our videos for more.

About this tutorial

Excel, Word and PowerPoint Tutorials from Howtech published this 1:39 video tutorial on October 26, 2016. It has been watched 6,097 times on YouTube.

Duration
1:39
Published
October 26, 2016
Views
6,097
Likes
12

Tags

Share

Further reading

  • Excel 2016: Track Changes and Comments - GCFGlobal.org edu.gcfglobal.org

    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…

  • How to Enable and Use Track Changes in Excel trumpexcel.com

    Here are the steps to disable ‘track changes’ in Excel: Go to the Review tab. In the Changes group, click on the ‘Track Changes’ and select ‘Highlight changes’. In the ‘Highlight Changes’ dialog box, uncheck the option…

  • How to Track Changes in Excel (Step by Step with Examples) wallstreetmojo.com

    Track Changes: Normal Comments: Track changes comments are auto inserted by the excel itself. No need for manually typing. Unlike track change comments, these types of comments are not auto inserted. We can extract all…

This tutorial in other languages