Add a new comment

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

  1. Select the cell in your table that needs a comment.
  2. Type or copy/paste the comment text in the special 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 mouse cursor to some other cell.

Edit a comment

Please follow these steps to edit a comment:

  1. Select the cell with the comment you want to edit or pick this comment 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
  2. Make the necessary changes. They will be saved automatically when you move to another cell.

Navigate among the comments

You can easily navigate among multiple comments in your table.

If you need to go to the cell with a particular comment, just click on this comment in the list on the Comments Manager pane.

Click on a comment 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 arrow buttons on your keyboard.

Delete comments

  1. To delete a comment, select it in the list of comments on the add-in pane. You can also pick the cell with it in your table and select it on the add-in pane.
  2. Click the Delete icon on the add-in toolbar.
    Click on this icon to remove a comment
    You can also press the Delete button on your keyboard to remove the comment.

Copy a comment to another location

It is possible to copy a comment to another cell or range.

  1. Click on the comment 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 icon on the toolbar.
    Click on this icon to copy a comment
  3. Select a destination cell or range in the table where you need to have the selected comment.

    Tip

    You can select multiple non-adjacent cells by keeping the Ctrl button on your keyboard pressed.

  4. Click on the Paste icon on the Comments Manager toolbar to have this comment for all the selected cells. Use the Paste icon to insert a comment

Add comment text to the cell

If you need to complement a commented cell with the text from the comment, for example, for printing, benefit from the Add comment text to the cell option.

  1. Select the cell that contains the comment text to be added.
  2. Click on the Comment to Cell icon and pick Add comment text to the cell. Click on the Comment to Cell icon and pick Add comment text to the cell
    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 contents with comment text. Click on the Comment to Cell icon and pick Replace cell contents with comment text
    The text from the comment will replace the cell contents.

    Tip

    You can drag and drop comment text from the add-in pane to any cell in your table to replace its contents.

Add cell text to the comment

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

  1. Select a cell with the text you want to add to its comment.
  2. Click on the Cell to Comment icon and pick Add cell text to the comment. Add cell text to the comment

Replace comment contents with cell text

  1. If you need to overwrite the comment contents with the cell text, select the corresponding cell in your table.
  2. Click on the Cell to Comment icon and pick the Replace comment contents with cell text option. Replace comment contents with cell text

Insert picture, author, date or time

You can add picture, author, date or time to a comment using the Insert option on the add-in toolbar.

Use this option to add picture, author, date or time to a comment
  1. Inserting a picture into a comment may be especially helpful for product lists. Instead of entering a product description you can simply insert its image as a comment.
    To insert a picture comment, select a cell and click on the Insert icon. Then pick the Insert Picture option from the list. Use this option to add picture comment
    You will see the Select Picture window where you can browse for the necessary image. Insert picture instead of entering a description
  2. If you want to add something to a comment, you can add author, current date or time. Just select a cell and click on the Insert icon. Pick the needed option from the list. Use this option to add picture, author, date or time to a comment
    Then you can type your addition to the comment text.

Export comments

If you want to get a list of all comments in a separate workbook, take advantage of the Export button in the bottom left corner of the add-in pane.

Take advantage of the Export button

After pressing the Export button, the comments will be copied to another workbook. The new table will have 2 columns: Cell address and Comment text.

Copy the comment contents to another workbook

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard