In Classic Office 2024, Excel - Cell comments display far away with connector line after sorting and I cannot retrieve them.

Dbril 0 Reputation points
2026-11-19T17:56:50.7+00:00

I have a Classic Office 2024 for home and business Excel worksheet with over 500 rows of classmates. I added notes/comments to some cells. After sorting the worksheet, when I hover over or open a note, the note box appears far away from the cell with a long connector line. The notes are attached to the correct cells, but their display positions are too far away to retrieve. Is there a way to reset all note/comment positions so they appear next to their cells again or a way to print the comments including the cell's locations? I want to retype the notes in another column visible at all times. AI was unable to provide me with a workable solution.

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

Answer accepted by question author

AI answer

2026-11-19T17:57:52.89+00:00

For legacy notes that still belong to the correct cells, run a VBA macro that moves every note box beside its attached cell; then export the note text and cell addresses to a worksheet if the goal is to retype them into a visible column.

Reset all note positions on the active worksheet

First, save a backup copy of the workbook. The macro changes note-box positions but does not change their text or attached cells.

  1. Open the affected worksheet.
  2. Press Alt+F11.
  3. Select Insert > Module.
  4. Paste this code:
Sub ResetNotePositions()
    Dim c As Comment
    Dim anchor As Range

    For Each c In ActiveSheet.Comments
        Set anchor = c.Parent
        With c.Shape
            .Left = anchor.Offset(0, 1).Left
            .Top = anchor.Top
            .Width = 200
            .Height = 60
        End With
    Next c
End Sub
  1. Place the cursor anywhere inside the macro and press F5.
  2. Return to Excel and hover over several affected cells. Each note should now open immediately to the right of its cell.

Excel exposes legacy notes through the worksheet’s Comments collection, and each comment has a Shape representing its displayed box.^1^ ^2^ Office 2024 supports VBA.^3^

If notes should appear on the left, replace:

.Left = anchor.Offset(0, 1).Left

with:

.Left = Application.Max(0, anchor.Left - 210)

The macro applies only to the currently active sheet. Activate another sheet and run it again if necessary. If macros must remain in the workbook, save it as Excel Macro-Enabled Workbook (.xlsm); otherwise, save the corrected workbook normally after removing the module.

Export every note with its cell location

This is the most reliable way to create a readable list for transferring the text into a permanent worksheet column.

  1. In the same VBA module, paste this second macro.
  2. Activate the worksheet containing the notes.
  3. Run ExportNotesWithLocations.
Sub ExportNotesWithLocations()
    Dim src As Worksheet, out As Worksheet
    Dim c As Comment, r As Long

    Set src = ActiveSheet
    Set out = Worksheets.Add(After:=src)
    out.Name = "Notes Export " & Format(Now, "hhmmss")
    out.Range("A1:C1").Value = Array("Sheet", "Cell", "Note")
    r = 2

    For Each c In src.Comments
        out.Cells(r, 1).Value = src.Name
        out.Cells(r, 2).Value = c.Parent.Address(False, False)
        out.Cells(r, 3).Value = c.Text
        r = r + 1
    Next c
    out.Columns("A:C").AutoFit
End Sub

The resulting sheet contains:

  • Sheet — source worksheet name
  • Cell — attached cell address, such as D147
  • Note — complete note text

The Comment object provides the parent cell and note text, so extraction does not depend on whether the floating note box is currently visible.^4^

After checking the export, copy column C into the desired visible column. Keep the original notes until the copied text has been verified.

Excel 2024 supports printing comments and notes:

  1. Select the affected worksheet.
  2. Go to Page Layout.
  3. In Page Setup, click the small dialog launcher in the lower-right corner.
  4. Open the Sheet tab.
  5. Under Comments and notes, choose At end of sheet.
  6. Select Print Preview before printing.

Annotations are excluded by default. At end of sheet combines them on pages appended to the worksheet; As displayed on sheet prints note boxes at their current floating positions, so it is less useful while they are displaced.^5^ The documented printing procedure applies to Excel 2024.^6^

If At end of sheet does not provide sufficiently clear cell labels in Print Preview, print the Notes Export worksheet instead; it explicitly records every note’s sheet and cell address.


References

  1. Worksheet.Comments property (Excel)
  2. Comment.Shape property (Excel)
  3. Office 2024 and Office LTSC 2024 FAQ
  4. Comment object (Excel)
  5. Page Setup | Microsoft Support
  6. Print comments and notes in Excel | Microsoft Support
AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Dbril 0 Reputation points
    2026-11-19T19:10:32+00:00

    I used AI's recommendation of Printing the annotations with their locations. This worked wonderfully for me as I only had about a dozen comments. Whew! I'm very happy.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.