This guide will explain how to fix comments that are far away from their attached cell in Excel.
Comments are a way to annotate your spreadsheet. They are often used by spreadsheet owners to explain a formula used in a particular cell or column.
When using comments in Excel, you may notice that the actual comments start moving away from their attached cell.
This often happens when new columns are added to your spreadsheet. This can be confusing for the spreadsheet user.
How can we ensure that the comments remain near the cells they are annotating?
We can edit the formatting of the comment to keep the positioning of the note fixed.
Now that we know what to do when comments are far away from the cell, let’s take a look at what this behavior actually looks like in Excel.
A Real Example of Comments Far Away From the Cell in Excel
In the following section, we will provide a few real examples where comments and notes are far away from the actual cells they are referring to.
First, let’s take a look at a real example of a note in Microsoft Excel.
The example below presents monthly sales data in a tabular format. Each month is further divided into various sectors. The spreadsheet owner has decided to add a note to the heading of Sector A. A red triangle market on the corner of the cell indicates that a note is attached to the cell.
The spreadsheet user can hover over the cell to reveal what the note says.
One issue that occurs with notes is that they may move around unexpectedly when adding or resizing rows and columns.
For example, we could insert a new column to the right of the cell with our note. When we try to edit our cell again, we can see that the cell has moved further from its cell.
The comment body may also change in length or width. When you try to extend the width of the column next to the annotated cell, the comment body also extends in width.
Do you want to take a closer look at our examples? You can make your own copy of the spreadsheet above using the link attached below.
If you’re ready to fix the issue of comments that are far away from its cell, head over to the next section to read our step-by-step breakdown on how to do it!
How to Fix Comments Far Away From Cell in Excel
This section will guide you through every step you need to fix comments or notes that pop-up far away from their cell. You’ll learn how to select a note and make it available for editing. You’ll learn how to use the Format Comment options to change how each comment is affected by surrounding cells.
Follow these steps to fix comments far away from the cell:
- First, select the cell that includes the comment. In this example, we’ll select cell C3.
- Right-click on the cell and click on the Edit Note option.
- Once you are in Edit mode, the comment should now have several squares around the perimeter. Right-click on the comment body and select the option labeled ‘Format Comment…’.
- In the Format Comment dialog box, navigate to the Properties tab. In the options for object positioning, select the option labeled ‘Don’t move or size with cells’. Click OK to apply these changes.
- We’ve now modified our comment to not move or size with cells. Even if you add another column next to the source cell, the note will remain in its original location and in its original dimensions.
These are all the steps needed to fix Excel comments that are far away from their source cell.
Frequently Asked Questions (FAQ)
- What is the difference between notes and comments?
Users may be confused about the difference between notes and comments. Before Office 365, the term “comments” referred to the usual text notes that you can add to cells.
However, during the latest Excel 365 update, comments now refer to the threaded discussion used when collaborating on a shared workbook. This is similar to the feature in Google Sheets that allows you to discuss certain parts of your document with your collaborators.
The feature previously known as comments are now called “Notes”.
This step-by-step guide should be all you need to fix comments that are far away from cells in Microsoft Excel. Our guide shows how to fix the issue easily by modifying the note formatting options for the comment.
Cell comments and notes are both useful tools to annotate and add remarks to your spreadsheet. Besides these tools, our website covers hundreds of other Excel methods and functions that you can apply to your own spreadsheets.
With so many other Microsoft Excel functions available, you can surely find one that suits your use case.
Are you interested in learning more about what Excel can do? Subscribe to our newsletter to look into the latest Excel guides and tutorials from us.