Office Settings & Configuration

Fix Excel Note Appears as a Line Instead of a Readable Comment

Guest Writer Oct 12, 2026 868 views

Question details

The user needs to restore visibility to Excel notes that are displaying incorrectly as mere lines without a readable text box.

How to Fix Excel Note Appearing as a Line Instead of a Box

Product: Excel
Device & OS: not provided
Scenario: Reading or editing notes attached to cells in an Excel spreadsheet.
Observed behavior: The note box is minimized or hidden, appearing only as a thin line pointing from the cell, making the text impossible to read.

Before you start

Save your current workbook before attempting to run any VBA macros or reloading the file to ensure no recent data modifications are lost.

Solution 1Recommended

Manually Resize the Excel Note

Quickly resolve the issue for individual notes by manually expanding the minimized note box using its sizing handles.

Enter Edit Mode

Right-click the specific cell containing the problematic note and select "Edit Note" from the context menu.

Drag to Enlarge

Locate the small square sizing handles at the end of the line. Click and drag these handles outwards to enlarge the note box until the text becomes visible.

Adjust and Save

Release the mouse button once the note box is properly sized, then click anywhere outside the cell to save the layout.

Solution 2

Automatically Resize All Notes using a VBA Macro

Use a VBA macro to automatically adjust the dimensions of all notes in the active worksheet to fit their text, saving time if many notes are affected.

Manage Spreadsheet Comments Easily

Use WPS Spreadsheet to View and Manage Notes

WPS Spreadsheet provides a stable, user-friendly interface for inserting, viewing, and editing comments without encountering glitchy rendering or sizing issues.

1. Open File in WPS Office: Launch WPS Spreadsheet and open your existing workbook.
2. Edit the Comment: Right-click the cell with the note indicator and select "Edit Comment" from the menu.
3. Resize Without Glitches: Click and drag the corner handles of the comment box to your preferred size. WPS will save the exact dimensions seamlessly.

Easily insert, edit, and safely resize comments without rendering errorsFully compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight application with smooth performance even on large datasetsFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel notes suddenly appear as thin lines?

This display error usually occurs due to a rendering glitch in Excel, accidental resizing by a user, or workbook file corruption that shrinks the note box's height and width dimensions to zero.

Can I format the text inside a resized note?

Yes. After you right-click the cell, select "Edit Note," and resize the box, you can highlight the text inside. Right-click the highlighted text and choose "Format Comment" to change the font, color, and text size.

How do I show or hide all notes in my worksheet at once?

Navigate to the "Review" tab on the top ribbon and click the "Notes" dropdown, then select "Show All Notes" to toggle the visibility of every note across the entire active sheet.

Office App Problems