How to Reference Comments in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes we need to create comments in Excel because it helps to remember any information for the user or the other users. If you don’t know how to do it then you have come to the right place. From here, you will learn 3 easy methods to reference comments in Excel with proper illustrations.


How to Reference Comments in Excel: 3 Easy Methods

Let’s get introduced to our dataset first, it represents some books’ published years and prices.


1. Using N Function to Reference Comments

In our very first method, we’ll learn how to reference comments using a function. The N function will be used here. The way is simple, after using any function, just use the plus sign and then insert the comment into the N function. Let’s insert a comment with the SUM function in cell D11.

Steps:

  • Write the following formula in Cell D11–
=SUM(D5:D9)+N("Wanna buy all")
  • Later, just press the ENTER button.

Then you will see that the comment exists with the SUM function and it doesn’t affect the SUM function.

Using N Function to Reference Comments in Excel

Read More: How to Add Comment in Excel Formula


2. Applying Shortcut Keys to Reference Comments

Also, we can use a keyboard shortcut to reference comments. The shortcut key is- SHIFT + F2.

Steps:

  • Select the cell where you want to add a comment. I selected Cell D11.
  • Next, press the SHIFT + F2 keys together.

Applying Shortcut Keys to Reference Comments in Excel

  • The comment box will pop up soon. Then just write the comment.

Applying Shortcut Keys to Reference Comments in Excel

Read More: How to Insert Picture in Excel Comment


3. Reference Comments Using Review Ribbon

In Excel 365, there are two ways to reference comments- New Note / New Comment. In the earlier versions, there was only one way.


3.1. Applying New Note Command

The Note command will work as the second method and will give the same output.

Steps:

  • Select a cell. I selected Cell D11.
  • click as follows: Review > Notes > New Note.

Using Review Ribbon to Reference Comments

  • Soon after the comment box will open up for the cell, just type the comment then.

Using Review Ribbon to Reference Comments

Read More: Difference Between Threaded Comments and Notes in Excel


Similar Readings


3.2. Applying New Comment Command

It is only available in Excel 365. By using this command the other user also can comment and chat.

Steps:

  • Select the cell where you want to add a comment. I selected Cell B9.
  • Next, click as follows: Review > New Comment.

Using Review Ribbon to Reference Comments

Soon after, a comment box will open up with your MS account name.

  • Type your comment and press the ENTER button.

Using Review Ribbon to Reference Comments

Then it will look like the image below.

Using Review Ribbon to Reference Comments


Similar Readings


How to Use Comments in Excel

In the previous section, we learned all the possible ways to add comments. Now we’ll learn how to use or operate comments.


Navigate Comments

If you have multiple comments in your worksheet then instead of clicking every time, you can navigate the comments using commands.

Steps:

  • To go to the next comment, just click as follows: Review > Notes > Next Note.

How to Use Comments in Excel

  • See, it moved to the second comment of my sheet. To go back to the previous comment, use the Previous Note command.


Show All Comments

If we wanna see all the comments at a time then it’s also possible in Excel.

Step:

  • Just click as follows: Review > Notes > Show All Notes.

How to Use Comments in Excel

Now have a look, all the comments show up.

Read More: How to Find Comments in Excel


Similar Readings


Hide Comments

As Excel can show all the comments at a time, of course, Excel can hide them all at a time too.

Step:

  • To do that, again click as follows: Review > Notes > Show All Notes.

How to Use Comments in Excel

Here you see, Excel has hidden all the comments.

Read More: How to Hide Comments in Excel


Copy Comments

If you want to use the same comment then no need to rewrite it, there is a way to copy the comment box. Here, I’ll copy the comment from Cell B5 to B9.

Steps:

  • First, copy Cell B5.

How to Use Comments in Excel

  • Then right-click on Cell B9 and select Paste Special from the Context menu.

How to Use Comments in Excel

  • After that, mark Comments and Notes and press OK.

Now see, the same comment is added to Cell B9.

Read More: How to Edit Comment in Excel


Delete Comments

Deleting any kind of comment is quite easy. For that, there is a Delete command in the Review ribbon.

Steps:

  • Select the cell from where you want to remove the comment. I selected Cell B5.
  • Then just click Review > Delete.

How to Use Comments in Excel

There is no comment icon anymore, which means the comment is deleted.

Read More: How to Format Comments in Excel


Format Reference Comments

Excel offers a lot of options to change the format of a comment box. From there, you can change the font, color, alignment, etc. let’s see how to do it.

Steps:

  • Right-click on the comment box and select Format Comment from the context menu.

Soon after a dialog box will open up.

Format Reference Comments

  • Let’s change something. I selected Italic from the Font style and red color.

Now you see, the comment has been changed according to my chosen format.

Read More: Creating and Editing Comments in Excel


Download Practice Workbook

You can download the free Excel workbook from here and practice on your own.


Conclusion

I hope the procedures described above will be good enough to reference comments in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo