Anchoring Comment Boxes in Excel (3 Easy Ways)

In this article, we will demonstrate anchoring the comment boxes in Excel. Anchoring comment boxes in a specific location is a tricky task. In Excel 365, comments are replaced by Notes, and comments are shown in a thread. But in the earlier versions of Excel, this feature is known as Comment. Today, we will demonstrate 3 easy ways. Using these methods, you can anchor comment boxes in Excel.


Download Practice Workbook

You can download the practice workbook from here.


3 Easy Ways of Anchoring Comment Boxes in Excel

To explain the methods, we will use a dataset that contains comments about some employees of a company. We will try anchoring the comment boxes. You can see Cells B10, D5, and D9 contain comments.

anchoring comment boxes in excel


1. Anchoring Comment Boxes Using Excel Options

In the first method, we will anchor comment boxes using the Excel options. Generally, Excel doesn’t show the comments until you place the cursor on the small red flag in the cell. So, we need to display the comments first. The steps of this method are easy to implement. So, let’s follow the steps below to learn the method.

STEPS:

  • In the first place, click on the File tab.

Anchoring Comment Boxes Using Excel Options

  • Secondly, select Options from the bottom left corner of the screen. It will open the Excel Options window.

  • In the Excel Options window, select Advanced.
  • Then, go to the Display section and select the “Indicators and notes, and comments on hover” option.
  • Click OK to proceed.

  • As a result, you will see the comments on the worksheet.

Anchoring Comment Boxes Using Excel Options

  • At this moment, put the cursor on the top side of the comment box of Cell B10 and it will change into a four-headed arrow symbol with the cursor.
  • Now, select the comment box and hold the Left Button of the mouse.

  • After that, drag the comment box to the desired position and let go of the mouse button to anchor it.

  • As a result, you will see the comment box of Cell B10 like in the picture below.

Anchoring Comment Boxes Using Excel Options

  • Finally, you need to do the above steps for each comment box for anchoring.

Read More: Creating and Editing Comments in Excel (4 Practical Examples)


Similar Readings


2. Use Review Tab for Anchoring Comment Boxes in Excel

The second method is similar to the previous one. But here we will use the Review tab to display the comments. Here, we will use the same dataset. Let’s follow the steps below to figure out the method.

STEPS:

  • Firstly, go to the Review tab and select Notes. A drop-down menu will appear.
  • Select Show All Notes from there.

Use Review Tab for Anchoring Comment Boxes in Excel

Note: In the earlier versions of Excel, you need to select the Show All Comments option from the Comments section in the Review tab.

  • Now, follow the steps of Method 1 and anchor the comment boxes one by one.

Read More: How to Populate Comment from Another Cell in Excel (and Vice Versa)


3. Apply VBA for Anchoring All Comment Boxes in Excel

In the previous two methods, we anchored the comment boxes one after another. But, using VBA, we can anchor all the comment boxes at once. Again, we will use the same dataset. But, this time comments are already displayed. You can use Method 2 for displaying the comments.

Apply VBA for Anchoring All Comment Boxes in Excel

Let’s follow the steps below to find out the results.

STEPS:

  • First of all, go to the Developer tab and select Visual Basic. It will open the Visual Basic window.
  • Alternatively, you can press Alt + F11 to open it.

  • Secondly, select Insert >> Module in the Visual Basic window to open the Module box.

  • Now, copy the code below and paste it into the Module box:
Sub Anchor_Comments()
Dim iComment As Comment
For Each iComment In Application.ActiveSheet.Comments
   iComment.Shape.Top = iComment.Parent.Top + 20
   iComment.Shape.Left = iComment.Parent.Offset(0, 1).Left + 20
Next
End Sub

Apply VBA for Anchoring All Comment Boxes in Excel

  • Press Ctrl + S to save it.
  • After that, go to the Developer tab and select Macros.

  • Then, select the desired code in the Macro box and Run it.

  • As a result, you will see the comment boxes at specific points from the cells.

  • Now, if you want to change the position of the comment boxes, change the underlined numbers in the Module box.
  • Here, we set a distance of 20 units from the top and left sides of the cells.

Apply VBA for Anchoring All Comment Boxes in Excel

  • Finally, after running the above code, you will see results like those in the picture below.

Read More: How to Hide All Comments in Excel (3 Simple Methods)


How to Change Size of Comment Boxes in Excel

In the last section, we will learn to change the size of comment boxes in Excel. Sometimes, we need to change the size of a comment box for bigger comments. We will describe the technique in the steps below.

STEPS:

  • In the first place, put the cursor on the top side of the comment box and it will change into a four-headed arrow symbol with the cursor.

How to Change Size of Comment Boxes in Excel

  • Secondly, right-click to open the menu.
  • Select Format Comment from there.

  • In the Format Comment box, select Size and change the Height and Width according to your preferences.
  • After that, click OK.

  • Finally, you will be able to change the size of the comment box.

Read More: How to Change Default Comment Font Size in Excel


Conclusion

In this article, we have demonstrated 3 ways of Anchoring Comment Boxes in Excel. I hope this article will help you to perform your tasks efficiently. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Also, you can visit the ExcelDemy website for more articles like this. Lastly, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo