Forum Discussion
comment not showing
in excel 365 i put a comment on a cell, then go back, but the comment can't be seen. i see the red triangle in upper right corner, an arrow like its point to a comment somewhere. problem is the comme...
thanks, cell size is normal, it is a very large spreadsheet, "edit" did not allow me to see my comments, recently added comments (they say "reply to comment) i can see, just not any of the ones that have been there a while, the arrow indicates to me that the comment window is way far away somewhere, but i can't get to it to see it.
It seems like you're encountering a peculiar issue with Excel comments not displaying properly, especially in a large spreadsheet. Here are a few additional troubleshooting steps you can try:
- Zoom In/Out: Sometimes, comments can appear off-screen due to zoom settings. Try zooming in or out to see if the comments become visible.
- Scroll to Cell: Click on a cell with a comment and try using the "Find & Select" feature to navigate to the cell with the comment. You can do this by pressing Ctrl + F and then typing the cell reference where you expect the comment to be located.
- Review Pane: Check if the Review Pane is open. Sometimes comments can be viewed and edited from there, especially if they're not visible on the sheet itself.
- Show All Comments: Excel has an option to show or hide comments. Make sure this option is enabled. You can find this option in the "Review" tab under "Comments."
- Use VBA: If none of the above solutions work, you might need to use a macro to locate and display the comments. Visual Basic for Applications (VBA) can be used to loop through all cells and display comments, even if they are hidden or misplaced.
- Copy to New Sheet: As a workaround, you can try copying the entire worksheet to a new sheet. Sometimes this can reset the formatting and display the comments properly.
- Check Compatibility Mode: Ensure that your Excel file is not in compatibility mode, as this can sometimes cause issues with newer features like comments.
- Update Excel: Make sure you're using the latest version of Excel 365. Sometimes, updating the software can resolve compatibility issues and bugs.
If none of these steps resolve the issue, it might be a more complex problem with your specific Excel file. In that case, you may need to give more information, about the excel version, operating system, storage medium, etc.