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.

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.

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

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

• 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

• How to Print Comments in Excel (4 Suitable Ways)
• How to Export Instagram Comments to Excel (with Quick Steps)
• [Fixed!] Comments in Excel Far Away from Cell (3 Possible Solutions)
• How to Remove Anchor in Excel (2 Easy Methods)
• Vlookup to Copy Comments in Excel (with a UDF)

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.

• As a result, you will find the comments on the sheet.

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

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

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

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

• 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

• How to Export Facebook Comments to Excel (2 Easy Ways)
• How to Add a Comment on a Graph in Excel (3 Easy Methods)
• [Solved!] Comments Are Not Displaying Properly in Excel
• How to Reset Comment Position in Excel (With Easy Steps)
• [Fixed!] Excel Comment Only Showing Arrow
• Difference Between Threaded Comments and Notes in Excel
• How to Anchor Cells in Excel (with Easy Steps)