Forum Discussion
Excel - Converting comments back to notes
In Excel, you can convert comments back to notes by following these steps:
- Select the cell containing the comment you want to convert back to a note.
- Right-click on the cell and choose "Edit Note" from the context menu. This will open the comment for editing.
- Copy the content of the comment.
- Right-click on the cell again and choose "Delete Comment" to remove the comment.
- Select the cell and go to the "Review" tab on the Excel ribbon.
- Click on "New Note" in the "Comments" group. This will insert a new note in the cell.
- Paste the content that you copied earlier into the note.
By following these steps, you'll be able to convert comments back to notes in Excel. If you have multiple cells with comments that you want to convert back to notes, you'll need to repeat these steps for each cell. The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
If that's not what you mean, then add more information about your specific situation. This link contains a list of information that may be needed: more information.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Thank you very much for providing guidance. Unfortunately, the excel file I use has thousands of notes over the 17 years of working on this file. I am hoping that someone can provide an easy fix to all thousand+ notes as the conversion to "Comments" isn't something that works for me.
Thank you again NikolinoDE for responding and trying to help. Any further guidance will be greatly appreciated.
add more information about your specific situation. This link contains a list of information that may be needed: more information.
