How Do I Stop My Notes from Moving in Excel (2 Useful Methods)

Get FREE Advanced Excel Exercises with Solutions!

The article will show you how to stop notes from moving in Excel. Sometimes you may need to give some instructions to your employees and for that reason, it will be good for you to put some notes beside their names if you use Excel to monitor them. But these notes may become a bit messy if you insert new columns afterward. I’ll be describing the necessary steps to fix these notes in their respective position.


Download Practice Workbook


2 Ways to Stop Notes from Moving in Excel

In the dataset, we have assigned some tasks to the employees and set the time duration for the completion of their task. We also added some instructions as notes.

how do i stop my notes from moving in excel intro


Problems of Moving Notes

If you don’t use proper settings and you insert new columns, your notes will move to other columns like the following picture.

This is a problem because we want our notes close to the employee names. And in the following description, I’ll give you two simple solutions to this problem.


1. Using Format Comment Feature to Stop Notes from Moving in Excel

This is one of the easiest ways to stop notes from moving in Excel. We will be using Note Property from the Review Tab for this. Let’s see the description below.

Steps:

  • If you don’t know how to put notes in Excel, select the cell that you want to be noted and go to Review >> Notes >> New Note

how do i stop my notes from moving in excel method 1

  • After that, right-click on the border of the note and select Format Comment.

  • The Format Comment window will appear. From Properties >> select Don’t move or size with cells. Do this for other notes
  • Later, click OK.

how do i stop my notes from moving in excel method 1

  • After that, the notes are fixed in their respective positions. They won’t move even though you insert a new column or enhance the column width.

If you increase your column width, it won’t change it’s place either.

how do i stop my notes from moving in excel method 1

Thus you can stop your notes from moving in Excel using the comment Property.

Read More: Difference Between Threaded Comments and Notes in Excel


2. Using VBA to Stop Notes from Moving in Excel

You can also stop your notes from moving by using Microsoft Visual Basic for Application (VBA). Let’s go through the procedure below for a better understanding.

Steps:

  • First, go to Developer >> Visual Basic.

  • After that, the VBA Editor will appear. Select Insert >> Module to open a new Module.

how do i stop my notes from moving in excel method 2

  • Later, type the following code in the VBA Module.
Sub StopNotes()
Dim Cmnt As Comment
For Each Cmnt In ActiveSheet.Comments
    Range("D" & Cmnt.Parent.Row).Comment.Shape.Placement = xlFreeFloating
Next Cmnt
End Sub

Code Explanation

  • First, we named our Sub Procedure as StopNotes.
  • After that, we declared variable Cmnt as Comment.
  • Later, we used a For Loop to detect all the rows that contain a note and fix them in their position.
  • Finally, we Save the code.
  • Now go back to your sheet and Run the Macro.

how do i stop my notes from moving in excel method 2

  • If you insert a column, it won’t move the notes.

how do i stop my notes from moving in excel method 2

  • Also, if you increase the column width, the notes won’t move either.

Thus you can stop your notes from moving in Excel using VBA.

  • Thereafter, if you want you can check the Property
  • To bring the Format Comment box follow Method-1.
  • Here, in Properties tab you will see the option Don’t move or size with cells is selected.

Read More: How to Remove Notes in Excel (5 Easy Ways)


Practice Section

In this section, I’ll give you the dataset of this article so that you can practice these methods on your own.

how do i stop my notes from moving in excel method 2


Conclusion

In the end, you will learn the basic ideas of how to stop notes from moving in Excel. This will be pretty annoying for you if you don’t fix the positions of the notes in their adjacent cells. If you have any better methods or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website.


Related Articles

Meraz Al Nahian

Meraz Al Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo