SOLVED

Excel comments

%3CLINGO-SUB%20id%3D%22lingo-sub-1750288%22%20slang%3D%22en-US%22%3EExcel%20comments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750288%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20using%20comments%20in%20excel%20spread%20sheets%20for%20some%20time%20without%20a%20serious%20problems%20but%20now%3C%2FP%3E%3CP%3EI%20find%20I%20am%20unable%20to%20change%20the%20font%20size%20and%20type%20in%20the%20comments.%3C%2FP%3E%3CP%3EI%20must%20have%20changed%20a%20setting%20somewhere%20%2F%20somehow%20but%20have%20no%20idea%20how%20to%20rectify%20this.%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated%20but%20I%20am%20not%20too%20technically%20savvy.%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1750288%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1750620%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20comments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750620%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F822274%22%20target%3D%22_blank%22%3E%40John_C_Addy%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20that%20you%20protected%20the%20worksheet%3F%20This%20could%20restrict%20you%20from%20editing%20the%20contents%20of%20a%20comment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1750663%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20comments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750663%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F822274%22%20target%3D%22_blank%22%3E%40John_C_Addy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%3C%2FP%3E%3CP%3ESo%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3ENevertheless%2C%20I%20would%20like%20to%20try%20to%20send%20you%20some%20information%20about%20the%20possibilities%20of%20comments%20in%20Excel.%20Its%20for%20Excel%202010%2C%202013%2C%202016..i%20dont%20try%20it%20in%20more%20versions.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EGo%20to%20the%20cell%20you%20want.%3CBR%20%2F%3EClick%20this.%3CBR%20%2F%3EThen%20right%20mouse%20button%20%3CBR%20%2F%3E%20A%20selection%20window%20will%20appear.%3CBR%20%2F%3ESelect%20the%20%22Insert%20Comment%22%20command.%3CBR%20%2F%3EA%20comment%20field%20appears.%3CBR%20%2F%3EYou%20can%20fill%20in%20and%20%2F%20or%20change%20this%20as%20you%20wish.%3CBR%20%2F%3EClick%20on%20another%20cell%20and%20the%20comment%20is%20hidden.%3CBR%20%2F%3EYou%20will%20see%20a%20small%20red%20triangle%20in%20the%20top%20right%20corner%20of%20the%20cell.%20If%20you%20go%20on%20it%20with%20the%20mouse%20(without%20pressing%20it)%20the%20added%20comment%20appears.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EFormat%20Comment%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3ETo%20change%20the%20settings%20of%20the%20comment%2C%20go%20to%20the%20cell%20with%20the%20mouse%20(click%20-%20with%20the%20left).%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EAfter%20clicking%2C%20please%20click%20the%20right%20mouse%20button%20(stay%20on%20the%20cell).%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EThe%20same%20menu%20appears%20as%20before%2C%20there%20you%20can%20edit%20comments%20(but%20also%20choose%20to%20show%20or%20hide).%20After%20clicking%20the%20%22Edit%20comment%22%20command%2C%20the%20comment%20appears%2C%20ready%20for%20editing.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EGo%20to%20the%20edge%20of%20the%20comment%20window%20and%20the%20mouse%20cursor%20becomes%20a%20small%20cross%2C%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3Ethen%20press%20the%20right%20mouse%20button%20and%20a%20new%20window%20will%20appear.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3ESelect%20%22Comment%20Format%22%20and%20a%20pop-up%20menu%20will%20appear%20with%20all%20possible%20settings%20that%20are%20available%20to%20you.%20Select%20which%20ones%20you%20also%20need%20and%20press%20Ok.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1758219%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20comments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758219%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20PReagan%20but%20it's%20not%20that.%20I%20can%20still%20create%20%2F%20alter%20the%20wording%20in%20a%20comment.%3C%2FP%3E%3CP%3EI%20just%20can't%20change%20the%20font%20type%20or%20size%20(or%20the%20colour)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone.

 

I've been using comments in excel spread sheets for some time without a serious problems but now

I find I am unable to change the font size and type in the comments.

I must have changed a setting somewhere / somehow but have no idea how to rectify this.

Any help would be appreciated but I am not too technically savvy. Thank you.

 

John

5 Replies

Hello @John_C_Addy,

 

Is it possible that you protected the worksheet? This could restrict you from editing the contents of a comment.

best response confirmed by John_C_Addy (New Contributor)
Solution

@John_C_Addy 

 

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.

@PReagan 

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)

@NikolinoDE 

Sorry Nikolino, this is my first post here.

I'm using Excel 2019 in Windows 10.

All I'm trying to do is change the font size from 9 to 10 and text colour in comments I have added to individual files which I had been able to do minutes earlier but then suddenly, without  any warning, I can't.

I can still create new comments and change the text in existing ones.

Thanks for any help.

Thank you for the feedback

No problem, I just pointed it out to you so that you should get the best possible solution.

Thank you for your understanding and patience.

Nikolino
I know I don't know anything (Socrates)