How to Add a Comment to a Cell in Excel

In this article you will learn how to add, edit and delete a comment in Excel.

‍

How is the comment feature useful?

• Comments can be used to provide feedback or instructions to other users who are working on the same spreadsheet. This can help to improve communication and reduce errors. 
• They are also used to document the purpose or meaning of a particular cell or range of cells. This can be helpful when sharing spreadsheets with others or revisiting a spreadsheet after a long period of time.
• In Microsoft 365 comments now allow users to tag other individuals with whom the file may be shared. Additionally, other users can respond within a comment sometimes also referred to as threaded comment. This features allows for stronger collaboration among users of shared workbooks 

‍

How to insert a comment in Excel?

Step 1: Select the cell where you want to add the comment.

Step 2: Right-click the cell and select "Insert Comment" from the context menu. Alternatively, you can click on the "Review" tab in the Excel ribbon, then click "New Comment".

Step 3: A text box will appear next to the selected cell. Type your comment into the text box.

Step 4: Click outside the text box to close it. The comment will remain visible in the cell as a small purple mark in the upper-right corner.

Step 5: To view the comment again, hover your mouse over the cell with the comment. The comment will appear in a popup box.

‍

Shortcuts to Add comment in Excel

Keyboard shortcuts can also be used to add comments to an Excel cell, however this will depend on the operating system being used. Please see below for the shortcuts to be used for Windows and MAC:

Windows:

1. Select the cell where you want to add the comment.
2. Press “CTRL” + "Shift" + "F2" keys on your keyboard.
3. Type your comment in the comment box that appears.
4. Press "Enter" to save the comment.

Mac:

1. Select the cell where you want to add the comment.
2. Press "Command" + "Shift" + "F2" keys on your keyboard.
3. Type your comment in the comment box that appears.
4. Press "Enter" to save the comment.

Editing and deleting comments in Excel

You can also edit or delete a comment by right-clicking the cell and selecting "Edit Comment" or "Delete Comment" from the context menu. Additionally, you can format the comment text by selecting it and using the formatting options in the Excel ribbon.

‍

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.

To learn more about LiveFlow, book a demo.

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides