Spreadsheets take teamwork. Multiple sets of eyes and opinions teaming up to collaborate is essential to create great files. Comments in Excel help to keep the discussion inside the file, but it’s best to remove them as you complete the file.
Let’s learn how to clear comments in Excel. When you’ve captured all feedback and are preparing a finished copy of the workbook, this is a helpful step to take.
Review Comments in Excel
First, as a reminder, comments are helpful to communicate as a team when you’re working in Microsoft Excel. Use them to leave points of feedback or questions for your collaborators. You can even tag others to collaborate in the spreadsheet.
Once
As you begin to wrap up your workbook, let’s double check that each comment has already been reviewed. on the ribbon, click on Review > Show Comments. You’ll see all comments in the workbook open in the sidebar. You can reply to any open comments in the open boxes, or click the dot icon and choose Resolve thread. That will clear out a single comment. Or, click Delete on the Review tab.
Satisfied that every comment is already addressed? Read on to clear them.
How to Clear Comments in Excel
Let’s clear all comments. Jump to the Home tab on Excel’s ribbon. Then, find the Editing tab. Click on the Clear dropdown. Then, choose Clear Comments and Notes. This will clear all of the comments and notes in the active sheet. If some comments are still visible, try pressing Ctrl + A in your workbook to select all cells, then follow the same steps.
Keep in mind that you’ll need to do this for each sheet in your workbook. You’ll need overly complex VBA code to clear the entire workbook, so make sure to repeat these simple steps for each sheet instead.
That’s it! Your Excel workbook is now neat and tidy so that it’s ready to share with a larger audience.
Coalesce Function in Excel