Formatting Issues

Fix Excel Note Boxes Becoming Compressed After Copying Worksheet

Anum Mushtaq Oct 15, 2026 869 views

Question details

The user needs to know why Excel note boxes lose their original dimensions and appear narrowed or compressed into a single line after copying a worksheet, and how to fix this display issue.

How to Fix Excel Note Boxes Becoming Compressed After Copying a Worksheet

Product: Excel
Device & OS: not provided
Scenario: Copying an entire worksheet containing multiple notes to a new location or within the same workbook.
Observed behavior: The note boxes in the copied worksheet appear compressed, narrowed, or squished into a single line, making the text unreadable without manual resizing.

Before you start

Verify if the issue persists when copying into a brand new workbook, and ensure you have saved a backup of your original file before modifying any formatting or application settings.

Solution 1Recommended

Match Source and Destination Worksheet Formatting

Notes are tied to the cells beneath them. Ensuring the copied worksheet retains the exact same formatting, cell dimensions, and zoom settings as the original can resolve display glitches.

Copying a worksheet can sometimes cause differences in cell sizes or zoom settings. Because notes are inherently linked to their background cells, any changes in row height, column width, or zoom can directly compress the note's appearance.

Check Zoom Levels

Look at the zoom slider in the bottom right corner of Excel. Ensure both the source worksheet and the newly copied worksheet are set to the exact same zoom percentage.

Verify Cell Dimensions

Compare the column widths and row heights between the two sheets. If the columns in the copied sheet are narrower, manually adjust them to match the original.

Check Note Formatting

Right-click an affected note and select 'Format Comment' or 'Format Note'. Verify that the font type, font size, and text emphasis match the original worksheet.

Manually Resize the Note

If the note remains compressed, click on the note box and drag the white sizing handles on its edges to manually restore its original dimensions.

Match Source and Destination Worksheet Formatting

Note Positioning: You can change how a note behaves by right-clicking it, selecting 'Format Comment', going to the 'Properties' tab, and choosing 'Don't move or size with cells'.

Solution 2

Copy the Worksheet Data in Smaller Sections

Copying heavy worksheets all at once can sometimes overload the clipboard and trigger formatting bugs. Copying in smaller batches helps isolate and prevent the issue.

Solution 3

Update or Repair Microsoft Office

Visual glitches like squished note boxes can be the result of a bug within the Microsoft Office application itself. Updating or repairing the software can fix these underlying issues.

Efficient Spreadsheet Management

Prevent Compressed Notes with WPS Spreadsheet

If Excel's formatting glitches are disrupting your workflow, try WPS Spreadsheet. It offers highly stable handling of notes, comments, and worksheet formatting, ensuring your data copies perfectly every time.

1. Open Your Workbook in WPS: Launch WPS Office and open your existing spreadsheet containing the notes.
2. Initiate Worksheet Copy: Right-click the worksheet tab at the bottom of the screen and select 'Move or Copy'.
3. Create a Duplicate: Check the 'Create a copy' box, select your desired location in the workbook, and click 'OK'.
4. Verify Formatting: Switch to the newly copied sheet. WPS Spreadsheet will have retained all cell sizes, zoom settings, and note box dimensions automatically.

Flawless retention of note and comment dimensions when copying worksheets.Highly compatible with all Microsoft Excel formats, including .xlsx and .xls.Lightweight software that copies heavy datasets without clipboard glitches.Completely free to use with a familiar, easy-to-navigate interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why do notes change size when I adjust column widths?

By default, note boxes and comments in spreadsheet software are set to 'Move and size with cells'. If you shrink a column or row beneath a note, the note box will compress accordingly. You can change this behavior in the note's formatting properties.

Is there a shortcut to resize all compressed notes at once?

There is no built-in keyboard shortcut to resize all notes simultaneously. You would either need to manually drag the borders of each affected note to restore its size or use a custom VBA macro script to loop through and reset their dimensions.

Does the zoom level permanently alter note sizes?

No, the zoom level only affects the visual display on your screen. However, if a worksheet is copied while set to a drastically different zoom level than the destination, it can trigger a visual glitch causing notes to temporarily appear compressed until the zoom or formatting is refreshed.

Document & File Issues