How to Insert, Edit, Or Delete a Comment In Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
How to Insert, Edit, or Delete a Comment In Excel
Post and read comments or carry on short conversations
By S.E. Slack S.E. Slack Senior Strategy & Editorial Director, Lifewire.com California Polytechnic State University at San Luis Obispo S.E. Slack has 30+ years' experience writing about technology. She has authored 12 books, thousands of articles, and worked for IBM and Microsoft. lifewire's editorial guidelines Updated on April 10, 2021 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook When you share an Excel spreadsheet with other people, questions or concerns about its content can come up occasionally. Instead of sending emails, just add a comment for others to see. Anyone using the spreadsheet can respond to a comment or even delete it. All comments are marked with the user’s name, dated, and time-stamped. Comments differ from Excel notes, which are similar to placing a yellow sticky note into the file. Other users cannot respond to a note in Excel but they can carry on small conversations using comments. The instructions below focus on the easiest ways to add, edit, and delete comments in Windows or on a Mac; scroll to the bottom of this article for Excel for Android instructions. This information in this article applies to Excel 2019, 2016, Excel for Mac, Excel for Android, and Excel 365. Inserting Editing or Deleting a Comment in Excel for Windows or macOS
How to Add a Comment
The easiest way to create a comment that others can respond to is follow these steps: In an open spreadsheet, right-click the cell where you want to make the comment. Click New Comment in the menu pane. In Start a conversation, type the comment you’d like to make. Click the green arrow to post your comment. To exit the comment, click anywhere on the spreadsheet. You probably noticed that once you clicked the green arrow, the comment automatically showed a Reply box. That’s where other readers can respond to the comment. They simply type in their reply and click the green arrow that appears to post their response back to you. This back-and-forth response through comments is called a Reply Thread. In some versions of Excel, including Excel 2016, you can also use the Ribbon to leave a comment. Just click the cell where you want to leave a comment, click Review on the Ribbon, and then click New Comment or Insert Comment. In the Web version of Excel, you can flag a comment for a specific reader by typing the @ symbol followed by the user’s name. Sometimes a drop-down list of users is also available in this version. How to Reply to a Comment
To reply to a comment someone else has left for you, you can either click on the cell and enter a reply immediately into the Reply box or you can right-click the cell where the comment is located and use the Reply box from there. Any cell with a comment attached to it is marked with a small, colored mark in the upper right corner. The color will vary depending upon your specific Excel setup. How to Edit a Comment
You can add more comments to a thread you started or you can edit a comment you already posted. To edit a comment you have made, follow these steps: Click the cell which has the comment. Move your mouse over the comment and you’ll see the Edit option appear. Click Edit. Type the changes you need to make. Click Save. If you decide midway through your change that your edit isn’t necessary, just click Cancel. How to Delete a Comment
Anyone can delete a comment in a spreadsheet, not just the person who started the comment thread. When a comment is no longer needed, right-click the cell where it is located and click Delete Comment from the menu. How to Show Or Hide All Comments
There are additional ways you can post and respond to comments in Excel. The Ribbon offers an entire Review section that allows you to open up a Comments pane to the right of the spreadsheet. You can easily bounce from comment to comment using this section of the Ribbon or add and delete comments. (Just be sure you have selected the correct cell before you use any of the Ribbon commands.) The Review tab also allows you to show or hide comments. To see all the comments in a spreadsheet, go to Review > Show Comments. To hide all the comments, use the same instructions and the comments will all disappear. The purple marks in commented cells, however, will always appear. Inserting Editing or Deleting a Comment on Android
How to Add a Comment
To add a comment in Excel for Android, you first need to work within the Review pane in the spreadsheet. To do that, follow these steps: Open the spreadsheet on your Android. Tap the cell where you would like to make the comment. Tap the up arrow at the bottom right of your screen to open the Menu pane. Tap Review in the menu at the top left of the Menu pane. This might show another command; tap the double arrows to open up the full menu of options and find Review. Type your comment using the onscreen keyboard. Tap the arrow to the right of your comment to post it. How to Reply to a Comment
To respond to a comment in Excel for Android spreadsheets, follow these steps: Tap the cell where the comment is located. Type your comments in the Reply box. Tap the arrow to post the comment. How to Delete a Comment Thread
To delete a comment thread in Excel for Android spreadsheets, tap the three horizontal dots at the top of the thread and tap Delete thread. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Pin a Comment on Instagram How to Pin Comments on Instagram How to Use the Comments Feature in Microsoft Word How to Delete a Comment on Instagram How to Insert Comments in Word How to Limit Comments on Instagram How to Use Google Sheets How to Merge and Unmerge Cells in Excel How to Delete a Comment on TikTok How to Strikethrough In Excel How to Hide and Unhide Columns, Rows, and Cells in Excel How to Delete a Blank Page in Word How to Delete Comments in Word How to Use the COUNTIF Function in Excel How to Delete a Comment on Facebook How to Purge Deleted Outlook Email Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies