# 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.

### 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.

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

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.

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

#### 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.

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

• Type your comment and press the ENTER button.

Then it will look like the image below.

## How to Use Comments in Excel

Steps:

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

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

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.

Now have a look, all the comments show up.

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.

Here you see, Excel has hidden all the 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.

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

• 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

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.

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

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.

• 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.

## 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

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

Advanced Excel Exercises with Solutions PDF