How to manage comments in Excel

The Comments Manager add-in makes managing Excel cell notes easier. Here you will learn how to add, copy, export, and modify comments quickly.

How to use the Comments Manager tool

Start Comments Manager

Run the add-in by clicking on its icon in the Utilities group on the Ablebits Tools tab:
Run the Comments Manager from the Ablebits Tools tab.

Add a new comment

You can easily add a new comment to the selected cell:

  1. Select the cell in your table that needs to be commented.
  2. Type or copy/paste the necessary text in the special yellow field on the add-in pane:
    Enter text to automatically add it as a comment.

That's it, the comment is already there. You can make sure of this by placing the cursor to some other cell.

Edit a comment

Select the cell with the comment you want to edit or pick this cell note from the list on the add-in pane. You will immediately see the comment contents at the top of the pane:
See the comment contents on the add-in pane.
Make the necessary changes, and they will be saved automatically once you move to another cell.

You can easily navigate among multiple comments in your table.

If you need to go to the cell with a particular note, just click on this comment in the list on the tool's pane:
Go to the comment by clicking on it in the list on the Comments Manager pane.
To navigate to the next or previous comment in the sheet, just use the up and down arrows on your keyboard.

Delete comments

There are two ways to delete comments in Excel:

  • Right-click the cell with it in the sheet and choose the Delete comment option from the context menu.
    Tip. You can also select the comment in the list on the add-in pane and the needed cell will be highlighted automatically.
  • Or, select the cell of interest and press the Delete button on your keyboard to remove the comment.

Insert author, date, or time to comment

To add author, date, or time to a note, just select a cell, click on the Insert icon on the add-in toolbar and pick the needed option from the list:
Use the Insert icon to add author, date, or time to a comment.
Then you can type your addition to the comment text.

Insert picture to a comment

Adding images into cell notes may be especially helpful for product lists. Instead of entering a product description, you can simply insert its image as a comment:
Insert picture as a comment to your table.

Add image to a cell note with Comments Manager

  1. To insert a picture comment, select a cell and click on the Insert/Delete picture icon. Then pick the Insert picture into comment option from the list:
    Use this option to add picture comment.
  2. You will see the Select Picture window where you can browse for the necessary image.
  3. Tip. You can always insert picture from clipboard into a comment. Just copy the image of interest into the clipboard, select the necessary cell, and pick the second option from the Insert/Delete drop-down list. Then press Ctrl+V on your keyboard and see the copied image in the cell's note.

Add image to a comment with the Insert Pictures tool

  1. To insert a picture comment, select a cell in your table, click the down arrow next to the Comments Manager icon in the Utilities group on the Ablebits Tools tab and select the Insert Picture option:
    Use the tool from a drop-down list to add images quicker.
  2. Browse for the necessary image in the Select Picture window.

Change the shape of your comment

To reshape the comment's outline, click on the comment border to enable the Change Shape option under Comments Manager and select the desired shape from the list you will see next to it. This will change the comment outline:
How to change the shape of the comment.

Delete pictures from comments

To remove picture from comment, select the cell that contains image in the note, click on the Insert/Delete icon and pick the corresponding option from the list:
Pick the last option to remove picture from comment.

Add cell text to the comment

If you need to complement a comment with the text from the cell, benefit from the Add cell contents to comment option:

  1. Select the cell with the text you want to add to its note.
  2. Click on the Add Contents icon and pick Add cell contents to comment:
    Add cell text to the comment.

Replace comment contents with cell text

  1. To overwrite the comment contents with the cell text, first, select the corresponding cell in your table.
  2. Click on the Replace Contents icon and pick the Replace comment contents with cell value option:
    Replace comment contents with cell text.

Add comment text to the cell

If you need to complement a commented cell with the text from its note, for example, for printing, benefit from the Add Contents option:

  1. Select the cell that contains the comment text you want to add.
  2. Click on the Add Contents icon and pick Add comment contents to cell:
    How to add cell note to the cell itself.

The text from the comment will appear at the end of the cell contents.

Replace cell contents with comment text

If your comment becomes more important than the cell text, you can overwrite the cell contents with the comment text:

  1. Click on the cell with the contents you need to replace with its comment text.
  2. Click on the Comment to Cell icon and pick Replace cell value with comment contents:
    Replace cell value with comment contents.

Copy a comment to another location

The add-in lets you copy a comment to another cell or range:

  1. Click on the note you want to copy in the list on the add-in pane or select the cell with it in your table.
  2. Click the Copy Comment icon on the add-in toolbar:
    Click this icon to copy cell note to another place.
  3. Using a small dialog window that appears, choose in the table or enter in the field a destination cell or range of cells where you want to have the selected comment.
Tip. You can select multiple non-adjacent cells by keeping the Ctrl button on your keyboard pressed.

Select destination cells or ranges to copy the comment there.

Click OK and the comment will appear in the selected cells.

Export comments

If you want to get a list of all comments in a separate workbook or a worksheet, take advantage of the Export button in the bottom right corner of the add-in pane:
Export comment to another location.

Depending on the option you pick, the comments will be copied to a new workbook or a new worksheet. The new table will have 2 columns: Cell address and Comment text:
Export all comments to a new workbook or a worksheet.

Post a comment

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.