In this video, learn how to use the new reply box to add comments and reply to comments in a threaded conversation when using the commenting feature in a cell in a workbook. Plus, learn how to use notes to mimic how comments used to be.
- [Instructor] If you're accustomed to working with comments here in Excel, which can come in very handy when sharing and collaborating with others, you're going to notice some changes. We're going to explore them now. You can have any worksheet in front of you. Let's go to a cell where we want to add a comment, just click it, and go up to the Review tab on the ribbon. You'll notice New Comment. Clicking here allows us to actually start a new conversation. Yes, it looks a little bit different, there's a field to fill in. If you're logged into your account, you'll see your credentials, the cell address where you're adding the comment, and a flashing cursor.
So we might want to type something in like, This value needs to be updated daily. When we click the Send button, we're actually sending this out, attaching the comment. Anyone we're sharing with will be able to see it. Notice that we also have an Edit button if we want to go in and make adjustments. We can save those changes. And at any time we can delete the entire thread by going up to the ellipses here and choosing Delete thread, but we'll leave it there.
Let's see what it's like to be at the other end, the receiving end. I'm going to go to a different tab here, where I see that somebody is actually working on this. It's a guest user, I can see that up here in Office 365. And, as I hover over the cell, I see the comment that was started, What formula was used here? And there's the Reply box down below, where I can answer. I might type something like, I'll add this later today. There we go, and clicking the Send button, you can see, adds to the conversation.
Again, this can be edited. I can delete my own reply here and start over, if I wanted to. Click in the background to close that up. Again, anything with a comment is flagged in the top-right corner. You can hover over that to see the conversation. So it looks totally different. Now, at any time we can see all the comments over on the right-hand side by choosing Show Comments. You can see them over here, now, in the Comments pane. And we can close that up when we don't need it. And if we wanted to delete the thread at the end, after we've finished up with this, we just go back to that cell, click the ellipses, and delete the thread.
Click in the background, you'll notice it's no longer flagged. And that's how we work with comments. So, if you're used to the old comments, where you actually attach a note to a cell, we do that with Notes now. You can see there is a Notes option here on the Review tab of the ribbon. Here's where we go to add new notes and move through the various notes that have been added. Clicking New Note will add a new note to the cell that is highlighted. And you can see, it's marked with your name. This is kind of like the old comments the way we used them before we had this new feature.
Click in the background to close that up. So, if you do like to use comments, they're very handy when sharing and collaborating with others. You're going to notice a brand new look and feel to this feature here in Office 365.
- Using natural language queries in Excel
- Getting writing assistance from Editor
- Using the Resume Assistant in Word
- Turning data into maps in Excel
- Setting access to linked files right within Outlook
- Creating better PowerPoint lists with Designer
- Using the math assistant in OneNote
- Working with Microsoft To-Do and Forms