All language subtitles for 5. Tracking Changes to Your Worksheet in Excel 2016

In this video we will track changes to keep a history of changes made to the law.

Chief you can use change tracking to record details about changes to your vote.

It helps in identifying changes made to the text and data in the log book.

Change striking is especially useful if multiple people work on the same log book or you off others

to review the vote.

Book 2 ton on change tracking for a book vote to review tab.

In the changes group click share log book in the share log book dialog box on the editing tab select

the allow changes by more than one user at the same time check box click advance tab on the track changes

click keep change history for and in the days box type the number of days of change history that you

want to keep click Okay save the log book if prompted to do so you can highlight changes as you would

when you do that Excel marks all changes with the highlighting color in the changes group click track

changes and then click highlight changes in the highlight changes dialog box make sure that the track

changes while editing checkbox is selected to view changes that were made after a particular date.

Select the then checkbox in the event list let us select.

Since I last saved you can select the whole tag box if you want to view changes that were made by a

specific user.

You can select a very tag box if you want to view changes for a specific range of says.

In that case type the cell reference of the voltage range in the Vale box.

Make sure that the highlighting changes on screen checkbox is selected click OK you may get a warning

message if there are no changes to be highlighted.

Let us make some changes in the worksheet and then track the changes in row 19.

We will enter targeted sales for that you type target in sell a 19 in Selby 19 and to seventy five thousand

and then sell f 19 and go for like ninety thousand.

These are the target figures for that you point the cursor to sales.

When we made changes Excel displays the changes we made to each of the cells let us copy the format

of rows 17 to row 19 select row 17.

Then on the Home tab click the Format Painter tool and then select row 19 Excel applies the formatting

pointer or so to Selby 19 Excel displays the changes to the value but does not say anything about the

underline since it is a formatting change.

Note Excel does not highlight formatting changes save the log book Let us also take the spellings in

the worksheet on the review tab in the proofing group click the spelling tool in the spelling dialog

box Excel displays and D in the northern dictionary box since it does not find this word in the standard

dictionary.

Click ignore once button Excel moves to the next spelling mistake for target in this additions box select

target and click change button Excel corrects the spelling and shows spellcheck completion dialog box

click okay in the changes group click track changes again and then click highlight changes in the event

list.

Let us select all.

Select the list changes on a new sheet.

Check box Excel inserts a new worksheet named history and displays all track changes on this sheet.