Forum Discussion
comment not showing
I am not able to accomplish the following from your solution. Where is the properties tab you are mentioning below. Thank you!
Then switch to the "Properties" tab and activate the selection "independent of cell position and size".
Then what you described should no longer occur.
Apologies for the confusion. It seems there was a misunderstanding in my previous response. In Excel, there isn't a "Properties" tab specifically for comments. Instead, you can access comment properties by right-clicking on the cell with the comment and selecting "Edit Comment." From there, you should see options such as "Format Comment" or "Edit Comment."
To make the comment independent of cell position and size, follow these steps:
- Right-click on the cell with the comment.
- Select "Edit Comment" from the context menu.
- In the comment box that appears, right-click again within the comment box.
- Choose "Format Comment" from the menu.
- In the Format Comment dialog box, go to the "Properties" tab (if available).
- Look for an option that allows the comment to be independent of cell position and size. This option may vary depending on your version of Excel.
- Check or enable this option if available.
- Click "OK" to apply the changes.
If you don't see a "Properties" tab or an option to make the comment independent of cell position and size, it's possible that your version of Excel or the specific settings in your spreadsheet might not have this feature. In such cases, you may need to explore alternative solutions or workarounds to address the issue of comments not displaying properly.
Thank you so much for your response. Unfortunately, I definitely do not have the Properties tab under format comment. But it would have been nice to have that fix.
Thank you!
If you use Excel for the web, Excel for web has a more limited feature set compared to the desktop version of Excel. Therefore, it's possible that certain features, such as the "Properties" tab within the "Format Comment" dialog, may not be available in Excel for the web.
However, Microsoft regularly updates and enhances Excel for the web, so it's also possible that new features have been introduced since my last update. To check if the "Properties" tab is available in Excel for the web:
- Open your Excel file in Excel for the web.
- Select a cell with a comment, then right-click on it.
- Look for options related to comment formatting or properties. If there's an option to edit or format the comment, explore that menu to see if there's an option to make the comment independent of cell position and size.
- If you don't see the desired options, it's likely that the feature isn't available in Excel for the web.
If you can't find the feature in Excel for the web, you may need to use Excel desktop version or consider alternative methods to manage comments in your spreadsheet.
It is always to your advantage if you always specify the Excel version, operating system, storage medium, etc. with every request.
- I use the software on my work laptop and have Office 365 and Windows 10. Thank you so much for your help.
