In this article you'll find out how to add comments to Excel cells, show, hide and delete them. You'll also learn how to insert a picture in a comment and make your cell note more eye-catching by changing its font, shape and size.
Suppose you have received an Excel document from another person and want to leave your feedback, make corrections or ask questions about the data. You can easily do this by adding a comment to a particular cell in the worksheet. A comment is often the best way to attach additional information to a cell because it doesn't change the data itself.
This tool can also come in handy when you need to explain formulas to other users or describe a certain value. Instead of entering text description you can insert a picture into a comment.
If you want to know more about this Excel feature, go ahead and read this article!
First I should say that the ways of inserting text and picture notes are different. So let's begin with the easiest of two and add a text comment to a cell.
By default, every new comment is labelled with the Microsoft Office user name, but this may not be you. In this case you can delete the default name from the comment box and enter your own one. You can replace it with any other text as well.
The text will go, but the little red indicator will remain in the upper-right corner of the cell. It shows that the cell contains the comment. Just hover the pointer over the cell to read the note.
I've just mentioned above how to view a single comment in the worksheet, but at some point you may want to display all of them at once. Just navigate to the Comments section on the REVIEW tab and click on the Show All Comments option.
One click and all the comments in the current sheet are displayed on the screen. After reviewing the cell notes, you can hide them by clicking Show All Comments again.
If you have a lot of comments in the spreadsheet, showing all of them at a time can complicate your perception of the data. In this case you can cycle through the comments using the Next and Previous buttons on the REVIEW tab.
If you need a single comment to stay visible for a while, right-click on the cell with it and choose Show/Hide Comments from the menu. You can also find this option in the Comments section on the REVIEW tab.
To put the comment out of sight, right-click on the cell and select Hide Comment from the menu or click on the Show/Hide Comments option on the REVIEW tab.
The rectangular shape, pale yellow background, Tahoma 8 font... A standard comment in Excel looks rather boring and unattractive, doesn't it? Fortunately, with a little bit of imagination and skill, you can make it more eye-catching.
The font of an individual comment is very easy to change.
You will see the comment box selected with the flashing cursor inside it.
There are two more ways to select the comment. You can either go to the Comments section on the REVIEW tab and click on the Edit Comment option or press Shift + F2.
The Format Comment dialog window will appear on your screen. Here you can pick the font, font style or size that you like, add different effects to the comment text or change its color.
If you are sick and tired of changing the font size of each single comment, you can apply it to all cell notes at once by changing the settings in your Control Panel.
If you want to use a different comment shape instead of the standard rectangle, first you need to add a special command to the Quick Access Toolbar (QAT).
You will see the Excel Options dialog window on your screen.
The Change Shape icon is added to the QAT in the top-left corner of the Excel window, but it is grayed out. To enable the icon, click on the comment border using the four-headed arrow.
When the option becomes available, open the Change Shape drop-down list and choose the shape you want.
After you've changed the comment shape it can happen that the text doesn't fit the comment box. Do the following to solve this problem:
Now when your comment has its individual style, hardly it will be ignored.
If you want the same comment in multiple cells of your worksheet, you can copy and paste it in other cells without changing their content.
You will get the Paste Special dialog box on the screen.
As the result, only the comment will be pasted into all the selected cells. If any cell in the destination area already has a comment, it will be replaced with the one you paste.
If you no longer need a comment, just follow the steps below to get rid of it in a second:
You can also go to the REVIEW tab in the Ribbon and click on the Delete icon in the Comments section to clear the comments out of the selected cell or range.
As soon as you do that, the red indicator will disappear and the cell will no longer contain the note.
It's high time to find out how to insert a picture comment in Excel. It may be very helpful when you want other spreadsheet users to have the visual presentation of your data. You can add the pictures of products, company logos, diagrams, schemes or fragments of a map as comments in Excel.
This task will take you some time, but I am sure it will be no problem at all. First let's try to do it manually.
If you don't want any text in your picture comment, just delete it.
The image appears in the Picture field of the Fill Effects dialog. To keep the picture proportions, check the box next to Lock Picture Aspect Ratio.
If you want to speed up the process of adding a picture comment to a cell in your worksheet, use Quick Tools by Ablebits.
Quick Tools for Microsoft Excel is a set of 10 great utilities that can make your daily tasks quicker and easier. Besides adding a picture comment to a cell, these tools can help you with math calculations, filtering data, converting formulas and copying cell addresses.
Now let me show you how Quick Tools can help you insert a picture into a comment.
After the installation the new Ablebits Quick Tools tab appears in the Ribbon.
When you rest the pointer on the cell, you'll see the picture you've just inserted in the comment.
Quick Tools also allows you to change the comment shape. First you need to click on the comment border to enable the Change Shape button in the Comment section. Then just pick the shape you like from the Change Shape drop-down list.
Now your comment will definitely catch everyone's interest because it contains the necessary details and visual support.
I hope after reading this article you will have no problem with adding, changing, showing, hiding, copying and deleting text and picture comments in Excel workbooks. If you have, just leave me a comment here and I'll do my best to help you! :)
42 responses to "How to insert comments in Excel, add pictures, show/hide comments"
Very use full information
I am using conditional formatting and I would like to have the comment box open automatically if the data entered makes the cell change color.
very very useful and important trick of excel
Very useful instruction. After you familiar with the steps, you work smart, work fun.
Works Great! Thank you
Great
Is there any way to compress images that were put inside comments?
great idea. nicely done
I am trying to have text and picture(s/diagramme(s) in comment boxes, but the picture/diagramme always takes up the whole comment box. How does one resize and position pictures? What am I doing wrong?Your answer will be appreciated.
Mike
Hey, thanks a ton. I've been digging around for some of this information and the depth/detail that you provided REALLY helped. Thank you!
When I right click on the comment box and select ‘format comment’ the only option on the pop up is ‘font’. No ‘colors and lines’ or anything else.
When I right click on the comment box and select ‘format comment’ the only option on the pop up is ‘font’. No ‘colors and lines’ or anything else........ if anybody know any other option......can u share with me that...
i would like to lot of thanks for this valuable information
This was really useful. Awesome option... Cheers...
IF VLOOKUP DATA MATCH THEN SHOW INSERT COMMENT
Good information about comment, otherwise normally people knows only "yellow square comment.
Good information about comment
Very good information, very very helpful to present work.
very helpful information
Wish there was a way to insert a picture from the clipboard instead of having to have it. I upgraded to Excel 2013 (from 2010) and I still don't see a way to do it.
how to add name in comment box or to edit while the name is already added when i am going to use comment option.
Great !, Thank you sir, really useful and helpful
Hi, Congratulations! This side is helpful. There is much to learn here. We can fix our mistakes from here. Thank you for this post shearing me.
Thanks a lot ..... Send updates my email .... Very useful
Thank you, Ramesh,
You can subscribe using RSS. Please find the icon at the page footer. Or like our Facebook page to get the updates.
thanks a lot for ur clear suggetion..
Hello,
I don't know if anyone else has this problem, but I tried this method of adding picture in the comments. However, when I save it, close it, and try opening it up again the Excel notifies me that the workbook has been corrupted and has to be "recovered." All the pictures (via comments) are all disappeared when I open the workbook back up. I believe it has something to do with privacy/Trust Center issue in my workbook. Can anyone help? Thank you.
Hello, I loved the content I hope to spend more times on the blog.
Thanks For giving New Techniques in Excel
Thank you so much. Wonderful and easy to follow directions. You helped me a lot.
Wonderful!! It's exactly what I require!! Much appreciated!
How add comment and image together ?
How to change user name in Excel comments, change comment shape, and more tips. Short videos and step by step written instructions. NOTE: Shapes and Pictures are not available with Threaded Comments.
Assuming that you have set the display of comments to show red markers and comments on hover, you may want to show all comments when you are working on them and then later hide the comments to display the red markers again.
To see how to add a picture to a comment, watch the steps in this short video. The written instructions are below the video. Instead of text, you can show a picture in an Excel comment. Watch the steps in this short video, and the written instructions are below.
I am having trouble even finding the show/hide comment command. For me it is non-existent. All there is is "show all comments." I just want an individual comment to show up. I tried modifying the display options but no luck.
I know this site offers quality based content and additional stuff, is there any other
web site which presents these information in quality?
This macro will be used to set photos or images in the background to the comment box from the computer. It will make comments and Excel look more attractive.
Excel displays the Select Picture dialog box, which looks very similar to a standard Open dialog box. Use the controls in the dialog box to locate the picture you want in the comment or note. Select the picture and click the Insert button.
Right-click the cell and then click Insert Comment (or press Shift+F2). If you're using Excel for Office 365, right-click the cell and choose New Note. Type your annotation text. Click outside the ce
Instead of text, you can show a picture in an Excel comment. Right-click the cell which contains the comment. Choose Show/Hide Comments, and clear any text from the comment. Click on the border of the comment, to select it.
I really informative article its to helpful i really enjoyed its reading this post enough to search high quality clothing manufacturers to helpful post thanks for sharing.