Using filters lets you see just the rows you want to see in a list while hiding other rows. Numerous options exist for text data, numerical data, and date data.
- [Instructor] When you share a workbook, you open the door to the idea that you might want to track changes on that workbook. Not only by you but also by other users. And remember, a shared workbook can be changed by multiple users working on that same file at the same time. The name of this workbook is unusual because it describes the fact that this workbook has been set up to be shared. So 11-Workbook After Sharing Setup. And because it is shared, we do see that word in brackets following it. Now, I'm gonna make a change or two here on this worksheet, the only worksheet in the workbook.
It's called Vendor Sales. So in cell D7, I'm gonna double-click here, and change this to be blue, and Enter. And also, this second 15 here should have been a 20. And also over here, these four entries should have been Wyoming. So I'll type WY and since they're all selected, press Control Enter and they're all changed at once. So I've made some changes. Alright. Now, in order to track changes, you'd think you'd go to the Review tab. And that's where you would've gone in the past but that option isn't available here. In Excel 2019, if you want to activate the feature called Track Changes, you go to the Quick Access Toolbar.
Most people keep this above the ribbon. Click the button on the right. Go down to More Commands. And in this dialog box, chose the drop arrow. Commands Not in the Ribbon, or All Commands. Slide down until the letter T. We'll see Track Changes, it's a legacy feature. We add it to the Quick Access Toolbar, click OK. Let's activate this. Click the drop button. Remember, it's in our Quick Access Toolbar now. Highlight Changes. And at different times, you might want to consider some of the different options available here about which changes you want to review.
Are you the only user? Possibly, but there could be others. Some options here to explore as well, too. Eventually, we might want to list these changes on a new sheet. Let's say, for now, we just want to highlight the changes on the screen. And we see some there. And as we slide over some of these, we're reminded who made the change and when. So at the time of this recording, it's August 1st of 2018 and that's what we're seeing here. And a reminder as to what was changed. This was 15, now it's 20. Now, if there are multiple users doing this, we would see all these, or potentially see all these, on the screen at the same time.
Let's go back here, that same button, and also, List Changes on a New Sheet. Click OK. Oops, we forgot to save, click OK. Let's save this workbook. Above the File tab, we can use that icon in the Quick Access Toolbar, Save. Now let's go back to the button. Notice how the highlighting has disappeared on the cells. Back to Track Changes, Highlight Changes. Let's list these changes on a new sheet. Didn't find any. Possibly, we'll check some other boxes here, uncheck the when, who, and where.
Come back and here. Since I last saved, oh, I didn't. I just saved so I haven't made a change since. How 'bout all by everyone? List These on a New Sheet, and we come back and there are the changes. One-by-one, we're seeing them all. And of course, in a real-life situation, with multiple users, probably see a much bigger list. And you probably saw the other option there on Track Changes, too. We could Accept or Reject changes. And presuming here, only one person is in charge, but that's something you have to work out as well, too.
But let's check out all the changes we made. And one-by-one, we could Accept them. I'll Accept that one. Come to think of it, why not Accept them all? Or maybe we'll Reject this one. We could do that or Reject them all. So we've got a number of options here to pursue. I'll just close at the moment. But you could imagine different approaches. And one suggestion I would make is: If you're gonna be using this feature, you and your coworkers probably get together in a conference room, kick a file around, a sample file, try different variations on what we've just seen here.
I think you'll find the feature incredibly valuable if it's necessary to keep track of changes.
- Explain the benefits of using Excel to create and manage spreadsheets.
- Recall the appropriate action for activating shortcut menus.
- Explore data entry, editing, and autofill.
- Name three actions that can be undone in an Excel worksheet.
- Identify the correct method for saving files in Excel.
- Apply unique font styles and effects to enhance charts.
- Recognize helpful keyboard shortcuts.