WEBVTT Kind: captions Language: en 00:00:12.039 --> 00:00:15.619 There may be some times when you're collaborating on a project, 00:00:15.619 --> 00:00:19.939 and you might have a coworker or a friend make changes to your workbook. 00:00:19.939 --> 00:00:22.189 For example, here, I'm working on a schedule for a 00:00:22.189 --> 00:00:23.640 company retreat, 00:00:23.640 --> 00:00:27.009 and I'll need a couple of my coworkers to fill in some of the blanks 00:00:27.009 --> 00:00:28.999 and possibly make corrections. 00:00:28.999 --> 00:00:33.660 I'm going to use two features that will really make this a lot easier: 00:00:33.660 --> 00:00:36.460 Track Changes and Comments. 00:00:36.460 --> 00:00:39.620 And these are both found on the Review tab. 00:00:39.620 --> 00:00:47.930 First, go to Track Changes, and click Highlight Changes. 00:00:47.930 --> 00:00:50.269 Put a checkmark where it says "Track changes while 00:00:50.269 --> 00:00:52.640 editing." 00:00:52.640 --> 00:00:55.820 And here you can customize which changes are highlighted, 00:00:55.820 --> 00:01:00.600 but I want to highlight all of them, so I'll just leave these as they are. 00:01:00.600 --> 00:01:07.640 Make sure "Highlight changes on screen" is checked, and click OK. 00:01:07.640 --> 00:01:10.000 And Excel needs to Save the workbook now, so just 00:01:10.000 --> 00:01:14.520 click OK to save it. 00:01:14.520 --> 00:01:16.480 And I'll pretend that I'm a coworker who's making 00:01:16.480 --> 00:01:17.960 changes to this workbook. 00:01:17.960 --> 00:01:20.540 I see a couple of items in the schedule that need 00:01:20.540 --> 00:01:24.050 to be changed, 00:01:24.050 --> 00:01:25.600 and when I do that, the cells will get this 00:01:25.600 --> 00:01:30.340 little triangle in the corner and also a border. 00:01:30.340 --> 00:01:36.160 And if somebody else makes changes, then they'll show up as a different color. 00:01:36.160 --> 00:01:37.771 When you hover over the cell, you'll be able to 00:01:37.771 --> 00:01:39.659 see exactly what was changed, 00:01:39.659 --> 00:01:42.680 and also who made the change. 00:01:42.680 --> 00:01:47.930 This workbook now has several different tracked changes, 00:01:47.930 --> 00:01:52.790 and I think it would be easier to read them if they were listed on a separate sheet. 00:01:52.790 --> 00:01:58.440 To do this, you'll first need to save your workbook. 00:01:58.440 --> 00:02:04.240 And then go to Track Changes and click Highlight Changes. 00:02:04.240 --> 00:02:08.209 And check List changes on a new sheet. 00:02:08.209 --> 00:02:10.040 Now when you first turn on Track Changes, you 00:02:10.040 --> 00:02:12.030 might not be able to select this, 00:02:12.030 --> 00:02:14.370 so if that happens you'll need to click OK 00:02:14.370 --> 00:02:20.950 and come back to this window, and then you should be able to select it. 00:02:20.950 --> 00:02:27.010 And it will create a new sheet called History. 00:02:27.010 --> 00:02:30.469 Now I can just glance over all of the different changes that were made, 00:02:30.469 --> 00:02:37.139 and I can also see which cells they're in. 00:02:37.139 --> 00:02:39.380 Right now, the changes that we've made are sort of 00:02:39.380 --> 00:02:40.730 temporary, 00:02:40.730 --> 00:02:44.389 and we'll need to either Accept the changes to make them permanent, or Reject 00:02:44.389 --> 00:02:45.859 them. 00:02:45.859 --> 00:02:52.200 So go to Track Changes and Accept/Reject Changes. 00:02:52.200 --> 00:02:54.029 I want to look at all of the changes that have not 00:02:54.029 --> 00:02:57.540 been reviewed, so I'll just leave this checked. 00:02:57.540 --> 00:03:00.480 You could also narrow it down by reviewer or to a 00:03:00.480 --> 00:03:03.500 specific range of cells. 00:03:03.500 --> 00:03:07.430 And then click OK. 00:03:07.430 --> 00:03:09.680 You'll be able to review each change, and you can 00:03:09.680 --> 00:03:12.329 choose to Accept or Reject it, 00:03:12.329 --> 00:03:15.650 but I know I want to keep all of these changes, so I'll Accept 00:03:15.650 --> 00:03:18.280 All. 00:03:18.280 --> 00:03:22.629 Another great reviewing feature that you can use 00:03:22.629 --> 00:03:24.510 is Comments. 00:03:24.510 --> 00:03:26.980 Let's say I want to make a suggestion or ask a 00:03:26.980 --> 00:03:29.239 question, without actually changing the cell. 00:03:29.239 --> 00:03:43.849 I'll just add a comment to the cell by first clicking on it and then selecting New Comment. 00:03:43.849 --> 00:03:46.150 And comments will show up as a little triangle in 00:03:46.150 --> 00:03:48.889 the top-right corner of the cell. 00:03:48.889 --> 00:03:50.469 You'll be able to read them when you hover the 00:03:50.469 --> 00:03:53.329 mouse over the cell. 00:03:53.329 --> 00:03:55.989 But I'd like to view all of them at once, so I'll 00:03:55.989 --> 00:04:01.909 click Show All Comments. 00:04:01.909 --> 00:04:05.239 You can edit a comment by clicking here. 00:04:05.239 --> 00:04:15.129 I'm just going add a sentence to clarify this question. 00:04:15.129 --> 00:04:18.930 I'm finished with this schedule now, so I'll delete all of the comments 00:04:18.930 --> 00:04:22.030 by selecting each one and clicking the Delete command. 00:04:22.030 --> 00:04:34.530 And I'll also turn off Track Changes. 00:04:34.530 --> 00:04:39.070 Just go back to Highlight Changes. 00:04:39.070 --> 00:04:45.510 And then uncheck this box. 00:04:45.510 --> 00:04:47.540 Once you do this, any tracked changes that you 00:04:47.540 --> 00:04:48.540 haven't reviewed 00:04:48.540 --> 00:04:52.200 will automatically be accepted, so just make sure that you really want to 00:04:52.200 --> 00:04:53.510 do this. 00:04:53.510 --> 00:04:55.000 And then click Yes. 00:04:55.000 --> 00:04:59.340 Track Changes and Comments are great features to 00:04:59.340 --> 00:05:01.870 use when you're collaborating on a project. 00:05:01.870 --> 00:05:03.780 And you don't necessarily have to be on a company 00:05:03.780 --> 00:05:06.340 network to take advantage of these features. 00:05:06.340 --> 00:05:08.960 You can still collaborate over email, or you could 00:05:08.960 --> 00:05:09.960 even just 00:05:09.960 --> 00:05:36.320 have all of the collaborators edit the workbook on the same computer.