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.


How to Stop Notes from Moving in Excel: 2 Ways

In the dataset, we have assigned some tasks to the employees and set the time duration for the completion of their tasks. We also add some instructions by adding notes in excel.

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 its 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: How to Remove 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 the Properties tab, you will see the option Don’t move or size with cells selected.


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


Download Practice Workbook


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, 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


<< Go Back to Notes in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Meraz Al Nahian
Meraz Al Nahian

Md. Meraz Al Nahian has worked with the ExcelDemy project for over 1.5 years. He wrote 140+ articles for ExcelDemy. He also solved a lot of user problems and worked on dashboards. He is interested in data analysis, advanced Excel, statistics, and dashboards. He also likes to explore various Excel and VBA applications. He completed his graduation in Electrical & Electronic Engineering from Bangladesh University of Engineering & Technology (BUET). He enjoys exploring Excel-related features to gain efficiency... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo