A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
- Open the affected worksheet.
- Press Alt+F11.
- Select Insert > Module.
- 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
- Place the cursor anywhere inside the macro and press F5.
- 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.
- In the same VBA module, paste this second macro.
- Activate the worksheet containing the notes.
- 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.
Print annotations with their locations
Excel 2024 supports printing comments and notes:
- Select the affected worksheet.
- Go to Page Layout.
- In Page Setup, click the small dialog launcher in the lower-right corner.
- Open the Sheet tab.
- Under Comments and notes, choose At end of sheet.
- 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