The Comments Manager add-in makes managing Excel cell notes easier. Here you will learn how to add, copy, export, and modify comments quickly.
Run the add-in by clicking on its icon in the Utilities group on the Ablebits Tools tab:
You can easily add a new comment to the selected cell:
That's it, the comment is already there. You can make sure of this by placing the cursor to some other cell.
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:
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:
To navigate to the next or previous comment in the sheet, just use the up and down arrows on your keyboard.
There are three ways to delete comments in Excel:
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:
Then you can type your addition to the comment text.
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:
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:
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:
If you need to complement a comment with the text from the cell, benefit from the Add cell contents to comment option:
If you need to complement a commented cell with the text from its note, for example, for printing, benefit from the Add Contents option:
The text from the comment will appear at the end of the cell contents.
If your comment becomes more important than the cell text, you can overwrite the cell contents with the comment text:
The add-in lets you copy a comment to another cell or range:
Click OK and the comment will appear in the selected cells.
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:
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:
