Forum Discussion
Excel - Converting comments back to notes
I was having an issue where my notes were not displaying properly. I converted my notes to comments but now want to convert back to notes. I only see how to convert to comments and not back to notes. Any help would be greatly greatly appreciated.
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.
Very detailed response that sounds helpful. However, over the last several days, Microsoft has seemingly chosen to eliminate all comments from all of my Excel spreadsheets. Over the past 30 years, I have created at least 500 teaching/learning modules that provide dynamic graphical displays of virtually every concept and method in college level mathematics and I've incorporated a series of Comments (that only appear when you hover over the cells -- about an average of 8 such comments in each module, so a total of roughly 4000 of them) as integral parts of the display to provide background information and suggestions for additional explorations on each of these topics without taking up all the screen space). Now, without any warning, all of these comments have been declared unreadable or some such and so the individual modules can only open after I accept the fact that the Comment contents are unreadable and hence eliminated. (Incidentally, I have made these modules available free to anyone around the world who wants to download them for use in their own classroom presentations or for students who wish to gain better understanding of the mathematical concepts and methods, so it is not at all a commercial operation.)
So, while your suggestion is reasonable (other than the scale of 4000 such Comments), there is no way that I can copy them over to Notes instead if I cannot access them. And I've tried with a variety of different versions of Excel that I have installed on various computers, going back as far at Excel 2007, all with no success. My last recourse, that occurs to me while I am typing, is to try this using Corel's QuattroPro that I haven't touched in more than 20 years. Hopefully, you can provide some better alternatives that will allow me first to access the Comments and second to transfer then over in a group within each module rather than as 8 or 10 or 25 individual items.
Thanks so much for any advice or suggestions you can make.
