Struggling with Excel comments not appearing when you hover your mouse over a cell? You’re not alone. Here, you’ll learn the simple steps to get your Excel comments working again, so you can focus on the task at hand.
Issue: Comments not appearing when cell is pointed to in Excel
One common issue faced by Excel users is the absence of comments when a cell is pointed to. This can cause inconvenience and affect productivity. Here’s a guide to resolve this issue:
- Check if comments are enabled in the worksheet. Go to Review > Comments and ensure that ‘Show all comments’ is checked.
- Verify if the comment is hidden. Right-click on the cell and select ‘Show/Hide Comments.’ If the comment is hidden, it will appear.
- Confirm if the comment is located outside of the window. Drag the comment box to a visible location within the worksheet.
- If the comment is not visible despite following the above steps, check if it’s present in another cell or worksheet by using the ‘Find and Replace’ feature.
Additionally, ensure that there are no spelling errors in the cell containing the comment. In case of confusion between strings in cells and comments, refer to our guide on ‘Comparing Strings in Excel.’
Pro Tip: To always show comments in Excel, go to File > Options > Advanced > Display options for this workbook > Show comments and indicators.
Image credits: chouprojects.com by Joel Duncun
Want to know why comments don’t show when you point to a cell in Excel? Look at these 3 areas:
- Comment settings turned off in the workbook.
- Using the “Show/Hide Comments” feature to hide them.
- If your Excel version doesn’t support comments.
Image credits: chouprojects.com by Joel Washington
Comment settings are turned off in the workbook
Excel users may encounter a problem where comments don’t appear when pointing to a cell. This issue can arise due to the workbook’s comment settings being turned off. This can be easily resolved by enabling the comment settings on the workbook.
To enable comment settings, open the review tab and click on ‘Show Comments.’ If this option is greyed out, it means that comments are disabled, and the ‘Allow’ users button needs to be selected in the ‘Restrict Access’ section under the ‘Review’ tab. Once enabled, comments will appear when cells are pointed at.
Furthermore, it’s essential to ensure that no filters are active in the sheet as they can also cause comments not to appear. It’s recommended to check column filters in case of hidden comments.
A user faced a problem where their colleague couldn’t see any comment when pointing at cells in an Excel file shared over email. The user had mistakenly turned off comment settings while editing, causing this issue. Upon corrective action taken by user, the problem was resolved.
Comments are like secrets – sometimes they need a little nudge to come out of hiding.
Comments are hidden using the “Show/Hide Comments” feature
When comments are not appearing in Excel even when cells are pointed to, it is likely that they have been hidden using the “Show/Hide Comments” feature. This can be easily resolved by unhiding the comments through the same feature or by adjusting the cell’s format to show comments.
To unhide comments, go to the “Review” tab and click on “Show All Comments.” Alternatively, right-click on the cell with the hidden comment and select “Show/Hide Comment.”
However, if this does not solve the issue, it could be related to cell formatting. Check if the cell is set to display only values and not comments. To change this, select the cell, go to “Format Cells,” click on “Custom,” and delete any format codes that may prevent comment display.
It is also possible that some previous actions have altered Excel’s default settings. In this case, try resetting all settings by going to File > Options > Customize Ribbon > Reset All Customizations.
Looks like the comments section in Excel is undergoing a version of the silent treatment.
Excel version does not support comments
One possible reason for comments not appearing when an Excel cell is pointed to could be that the specific version of Excel being used does not support comments. This can happen if the user is using an older or limited version of Excel. If this is the case, the user may need to upgrade to a newer version of Excel that supports comment functionality.
In addition, it is important to note that some versions of Excel have specific settings or configurations that must be enabled in order for comments to appear when cells are pointed to. For example, if the “Show Comments” setting is turned off, comments will not appear regardless of whether or not they exist in the worksheet. Users should check their Excel settings and preferences to make sure everything is properly configured.
Another possible cause could be inadvertent deletion of comments by human error. This can happen if a user accidentally deletes comments while navigating through a spreadsheet or while making edits to a cell. It’s important to use caution when manipulating data in Excel spreadsheets and always make backups before making significant changes.
To resolve these issues, users can try enabling any necessary settings within their Excel program, upgrading to a newer version of Excel with full comment functionality, and being more careful when making edits within spreadsheets to avoid accidentally deleting important information.
Let’s hope these troubleshooting steps work better than my attempts to fix my love life.
- Troubleshoot the issue of missing comments in Excel.
- Do this by turning on comment settings in the workbook.
- Then, use the “Show All Comments” feature to unhide them.
- Lastly, upgrade your Excel version to one that can support comments.
Image credits: chouprojects.com by David Jones
Turn on comment settings in the workbook
To ensure that comments are visible in Excel when a cell is pointed to, it is essential to activate the comment settings in the workbook.
Here’s a 4-step guide on how to turn on comment settings in the workbook:
- Open Excel and click on File in the top left corner.
- Select Options from the drop-down menu.
- In the Excel Options dialog box, select Advanced from the list of options.
- Scroll down to the Display section and confirm that “Show comments indicator” and “Comments & indicators” are checked.
In addition, check if any comment filters have been enabled. These filters can sometimes hide comments from view.
It’s worth noting that turning on comment settings will not make existing comments visible if they were previously hidden. According to Microsoft Support, some worksheet protection options can also prevent cell comments from being displayed.
A true fact: According to Microsoft, Excel is currently used by over 750 million people worldwide.
Bringing hidden comments to light has never been easier, thanks to the ‘Show All Comments’ feature – let the commenting chaos commence!
Unhide comments using the “Show All Comments” feature
To reveal comments that don’t appear when the cell is pointed to in Excel, you can use the handy feature “Show All Comments”. By following these four simple steps, you can quickly unhide those hidden comments!
- Open the worksheet containing the comments that are not showing up.
- Click on the “Review” tab located on the top ribbon.
- From there, click on “Show All Comments”, which is located under the “Comments” section.
- All previously hidden comments should now be visible!
It’s important to note that this feature will unhide all comments present in your worksheet. If you only want to reveal a specific comment, hover over the cell containing it and click its associated button.
When using “Show All Comments”, keep in mind Excel has a limit on how many comments can be visible at once (displayed as tiny red triangles). If you exceed this limit, some comments may still remain invisible.
Although this troubleshooting step seems like a repetitive task, it is an essential feature for many businesses and individuals who rely heavily on Excel. In fact, without it, users would struggle to unveil pertinent information from prior users or annotators of their spreadsheet data.
Time to upgrade Excel, because the only comments you’re getting are from your mother-in-law on your recipe spreadsheet.
Upgrade Excel version to one that supports comments
To enable comments in Excel, update to the latest version that supports it. Here are five simple steps to follow:
- Go to ‘File’ menu and select ‘Account’.
- Under ‘Product Information’, click on ‘Update Options’ and select ‘Update Now’.
- Select the Microsoft Office Product you want to update and click on ‘Update’.
- Once updated, launch Excel, add a comment in a cell and check if it appears.
- If not, try uninstalling and reinstalling Microsoft Office.
Moreover, updating your Excel not only enables comments but also provides new features and bug fixes that enhance your experience.
If upgrading doesn’t resolve the issue, clear the cache files of Excel or repair your Office installation. Also, ensure that Microsoft’s XML Parser is installed on your computer.
In addition to these technical solutions, organize your worksheets better by avoiding duplicate names for sheets or workbooks. This helps prevent file corruption issues.
By following these steps and suggestions, you can ensure comments appear when pointed at cells in Excel.
FAQs about Comments Don’T Appear When Cell Is Pointed To In Excel
Why don’t the comments appear when I point to a cell in Excel?
If the comments don’t appear when you point to a cell in Excel, you may have accidentally hidden them. To unhide the comments, follow these steps:
- Right-click on the cell with the comment.
- Select “Show/Hide Comments” from the drop-down menu.
- Check the box that says “Comment Indicator Only.”
- Click the “OK” button.
If the comments still don’t appear, make sure that they are not hidden by filters or an autofilter.
How do I show or edit comments in Excel?
To show or edit comments in Excel, follow these steps:
- Select the cell that has the comment you want to show or edit.
- Click on the “Review” tab.
- Click on the “Show/Hide Comment” button.
- Edit the comment as needed.
- Click outside of the comment box to close it.
Can I view comments in Excel without pointing to the cell?
Yes, you can view comments without pointing to the cell in Excel. To do so, follow these steps:
- Click on the cell that has the comment you want to view.
- Click on the “Review” tab.
- Click on the “Previous” or “Next” button in the “Comments” group to scroll through the comments on the worksheet.
Why aren’t my comments printing in Excel?
If your comments aren’t printing in Excel, check to make sure the “Print Comments” option is selected. To do so, follow these steps:
- Click on the “File” tab.
- Click on “Print.”
- Click on the “Page Setup” link at the bottom of the print options.
- Click on the “Sheet” tab.
- Check the box that says “Comments.”
- Click “OK” to close the Page Setup dialog box.
- Click “Print” to print the worksheet with comments.
How do I copy comments in Excel?
To copy comments in Excel, follow these steps:
- Select the cell with the comment(s) you want to copy.
- Right-click on the cell and choose “Copy” or press “Ctrl+C” on your keyboard.
- Select the cell where you want to paste the comment(s).
- Right-click on the cell and choose “Paste” or press “Ctrl+V” on your keyboard.
Can I change the font and size of comments in Excel?
Yes, you can change the font and size of comments in Excel. To do so, follow these steps:
- Select the cell with the comment you want to change.
- Click on the “Review” tab.
- Click on the “New Comment” button.
- Right-click on the border of the comment box and choose “Format Comment.”
- Click on the “Font” tab.
- Choose the desired font, size, and other settings for the comment text.
- Click “OK” to close the Format Comment dialog box.