All About “Comments” in Excel

You may have added “Comments” in Excel. However, it is not just limited to adding a new comment. Fortunately, you can do many more exciting things with “Comments” in Excel.

In this blog, we would unlock all the things that you can do with the “Comment” functionality of Excel.

What is an Excel “Comments” Functionality?

The Excel “Comments” gives us information about a particular cell. It means, comments are added to the cell and it gives additional feedback about the cell.

For example, if you are working with an important Excel Worksheet and you want that whose so ever opens this excel, later on, should know what does the content in a particular cell depicts. In that case, you can (amongst many other options) insert a new comment so that the new user can read the comment and understand the purpose of a particular cell.

How to Add a New “Comment” to Cell in Excel?

To add a new comment to an Excel Cell, follow the below procedure.

1. Select the cell to which you want to add a new comment.

2. In the ribbon bar, click on the tab “Review”. Under the “Comment” group, click on the option “New Comment”.

Review New Comment in Excel

You would notice that Excel inserts a comment box for the cell.

New Comment Added To Cell

You can type anything of your choice in this comment box and it would remain saved.

Writing or Editing Comment in Excel

Show or Hide “Comments” in Excel

As soon as you enter any text in the comment box and click on any of the cells in Excel, you would notice that the comment would disappear. Don’t be worried. It has just got hidden. It is still available in Excel Cell.

As a result, a “Red” mark on the top-right of the Excel cell. This shows that this cell contains a comment (which is not visible at the moment).

Red Triangle on TopRight Corner - Comment

To show the comment, select the cell. click on the tab – “Review” .  Under the “Comment” group, click on the button “Show/Hide Comment”.

The comment is now visible (as you can see from the image below)

Show or Hide Comment in Excel

Similarly, to hide the comment, again click on the same option – “Show/Hide Comment”. The comment would hide.

Hide Comment in Excel

Copy and Paste “Comments

To copy and paste the comment, follow the below steps:

Select the cell that contains the comment.

Press Ctrl+C on your keyboard to copy the comment.

Now, select the cell to which you wish to paste this comment.

And press Ctrl+Alt+V on your keyboard. The “Paste Special” box would appear on your screen. In this dialog box, select the radio button “Comments” and click on the “OK” button.

Copy and Paste Comment in Excel
Copy and Paste Comment in Excel

Show/Hide All the “Comments” at One Go

To show or hide all the comments at one click, click anywhere on the excel worksheet and then under the group “Comments” (in ‘Review’ tab), click on the option “Show All Comments”.

As a result, you can see that all the comments are visible at one go.

Show or Hide All Comments in Excel

Reposition and Resize the “Comments

To reposition the comments in Excel, hover your mouse to the border of the comment box. The mouse cursor would change to a Plus sign.

Left-Click on your mouse (do not release it) to hold the comment and then drag the comment to the location where you want to place it.

Move Comment Box in Excel

To resize the comments box, hover your mouse cursor to the squares on the border of the comment box. The mouse cursor would change to a line with arrows on both sides.

Now, left-click on your mouse (do not release it) and drag it resize the comment. Release the mouse once finished.

Increase Decrease Comment Box Size Excel

Change Background Color “Commentin Excel

Changing the background color of an Excel comment can help you to classify the important excel comment (to which you want to draw user’s attention). You can, for example, give ‘Red’ as the comment background color for the highly important comment, etc.

This can be done using the “Format Comment” functionality of Excel.

Follow the below procedure:

Select the comment for which you want to change the background color. Then, right-click on the border of the comment (as demonstrated in the screenshot below).

From the list of drop-down option, click on the option ‘Format Comment’.

Format Comment Excel

This would open the “Format Comment” dialog box on your screen.

In this dialog box, go to the “Colors and Lines” tab. In the “Fill” section of this tab, select the color of your choice from the list of colors available. And then press “OK” to activate the option.

Change Fill Color of Comment Excel

You would notice that the background color of the selected comment box changes to ‘Red’.

Changing Fill Color of Comment Box Excel Result

Similarly, you can change the border settings of the comment box. For Example, changing the border color, style, thickness, etc. using the line section of the “Colors and Lines” tab.

Aligning the Text in Comment Box

To adjust the position of the content within the comment box, follow the below procedure:

Select the comment to which you want to make the changes.

Open the “Format Comment” dialog box, by right-clicking on the selected comment box and selecting the option ‘Format Comment’.

Go to the “Alignment” tab, and make the settings as per your need.

Align Text inside Comment Box

How to Print Excel Comments?

To print the Excel Comments, we need to make some changes in the default settings in printing. Follow the below steps to do the same:

Go to the “Page Layout” Tab. Under the group “Sheet Options”, click on the dialog box launcher (It is a small square with an arrow on the bottom-right corner of the group).

Page Setup dialogbox Launcher Excel

A new dialog box would appear on your screen – ‘Page Setup’.

Under the “Sheet” tab, change the print comment settings from ‘(None)’ to ‘As displayed on Sheet’.

Now click on the “Print Preview” button to check the preview of this setting.

Print Comments As Displayed Excel

You would see that Excel shows the comments in the Print Preview.

Print Comments as Displayed Print Preview

You can even print the comments at the end (after all the page contents end). For that, select the option “At end of sheet” as shown in the screenshot below:

Print Comments At Sheet End Excel

Changing the Font Settings of Comment

To change the “Font” settings for Excel Comment, follow the below steps:

Select the comment. Right-Click on the border of the selected comment and click on the option ‘Format Comment’.

As a result, the ‘Format Comment’ dialog box will appear on your screen. Here, go to the tab named “Font”. There you can find all the font settings for a selected comment(s) including Font Style, Font Size, Font Color, etc.

Change Font and Font Size of Comment Excel

Make changes in the font settings as per your choice. As a result, you would see that the excel comment font, etc. settings updates.

With this you have reached to the end of this blog.

There is one bonus lesson for you on “Bonus Trick on Excel Comment Feature“. Click on the URL to learn more about it.

Leave a Comment