Forum Discussion
Excel comments
- Oct 06, 2020
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file.
So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
* Knowing the Excel version and operating system would also be an advantage.
Nevertheless, I would like to try to send you some information about the possibilities of comments in Excel. Its for Excel 2010, 2013, 2016..i dont try it in more versions.
Go to the cell you want.
Click this.
Then right mouse button
A selection window will appear.
Select the "Insert Comment" command.
A comment field appears.
You can fill in and / or change this as you wish.
Click on another cell and the comment is hidden.
You will see a small red triangle in the top right corner of the cell. If you go on it with the mouse (without pressing it) the added comment appears.Format Comment:
To change the settings of the comment, go to the cell with the mouse (click - with the left).
After clicking, please click the right mouse button (stay on the cell).
The same menu appears as before, there you can edit comments (but also choose to show or hide). After clicking the "Edit comment" command, the comment appears, ready for editing.
Go to the edge of the comment window and the mouse cursor becomes a small cross,
then press the right mouse button and a new window will appear.
Select "Comment Format "and a pop-up menu will appear with all possible settings that are available to you. Select which ones you also need and press Ok.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Hello John_C_Addy,
Is it possible that you protected the worksheet? This could restrict you from editing the contents of a comment.
Thanks PReagan but it's not that. I can still create / alter the wording in a comment.
I just can't change the font type or size (or the colour)