How to Reset Comment Position in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes while working on excel, we insert too many comments and notes, and often their position is needed to change so that they don’t hide the necessary data behind them on the worksheet. But subsequently, we may need to reset the comment position. In this article, I will show you how to reset comment position in excel.

Table of Contents hide

Download Practice Workbook

Step-by-Step Procedures to Reset Comment Position in Excel

Step 01: Open Visual Basic Editor

Step 02: Enter Code in Editor

Step 03: Run VBA Code

Things to Remember

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Resetting Comment.xlsm

Step-by-Step Procedures to Reset Comment Position in Excel

To reset comment position in excel, I have divided the whole process into 3 very simple and straightforward steps for convenience. In the first step, we will open the visual basic editor. In the 2nd step, we will write the code on the visual basic editor. Finally, we will run the code and get our desired result. So not wasting time anymore, let’s start the process with the first step. But before discussing the solution, let’s see what the problem looks like. Here is a picture of an excel worksheet where the default positions of comments have been changed for some reason.

Now, we want to reset their positions. We can do that by running a VBA Code. It is a super easy process. You just only need to run a VBA code and the code will itself automatically reset the position of the column. Follow the steps below.

Step 01: Open Visual Basic Editor

Excel allows us to codify customized instructions in the Visual Basic Language. To write code, excel provides an editor. In the first step, we will be opening the editor.

First of all, open the Visual Basic Editor. To do that, first, go to Developer Tab and then click on Visual Basic. You can also use the shortcut key Alt+F11.

Now You should see a Visual Basic Editor window like this.

As we can see, the editor is currently empty. So, we need to insert a new module here.
After that, click on Insert and then Module.

Consequently, you will see an empty module like this below.

Now the only tasks remaining are to write code and run it.

Step 02: Enter Code in Editor

Here a code is given below. First, copy the code by pressing Ctrl+C and then paste the VBA code into the Editor by pressing Ctrl+V.

Sub ResetComment()
Dim rComment As Comment
For Each rComment In Application.ActiveSheet.Comments
   rComment.Shape.Top = rComment.Parent.Top + 5
   rComment.Shape.Left = rComment.Parent.Offset(0, 1).Left + 5
Next
End Sub

The code on the editor should look like this.

Now the only task remaining is to run the code.

Similar Readings

Step 03: Run VBA Code

So, you can run the code by clicking the Run command on the command bar or pressing the F4 key.y

After running the code, you will see that all the comments’ positions have reset to default.

Things to Remember

You need to save the current excel file in .xlsm( macro-enabled file) format if you want to further use the code in the future

Conclusion

That is the end of this article. I hope, now you have a clear understanding of how we can reset comment position in excel. If you find this article helpful, please share this with your friends. Moreover, do let us know if you have any further queries. Finally, please visit Exeldemy for more exciting articles on Excel.