Formatting Issues

How to Save Resized Excel Note Boxes in Microsoft 365

Ayan Masood Oct 12, 2026 869 views

Question details

The user needs to ensure that custom sizes applied to Excel note boxes are permanently saved and do not reset upon reopening the file.

How to Keep Excel Note Boxes Resized After Saving

Product: Microsoft Excel (Microsoft 365)
Device & OS: Windows
Scenario: Adjusting the dimensions of an Excel note for better readability, then saving the workbook to preserve the new formatting.
Observed behavior: The manually resized note box fails to retain its adjusted dimensions and reverts to its original default size after the workbook is closed and reopened.

Before you start

Ensure your Microsoft 365 subscription is fully updated and save a backup copy of your workbook before testing in Safe Mode or running a software repair.

Solution 1Recommended

Test Workbook in Excel Safe Mode

Running Excel in Safe Mode helps determine if a third-party add-in is interfering with the note-sizing functionality.

Excel notes should normally retain their manually adjusted size by default. If they are resetting, an active add-in might be overriding your formatting changes upon saving.

Close the workbook

Save any necessary changes to your current workbook and close Microsoft Excel completely.

Launch Excel in Safe Mode

Press the 'Windows Key + R' to open the Run dialog box. Type 'excel /safe' and press Enter.

Resize and save the note

Open your problematic workbook from within Safe Mode. Resize the note box by dragging its edges, then press 'Ctrl + S' to save.

Reopen to verify

Close the workbook and reopen it normally. If the note remains resized, you will need to disable your Excel add-ins one by one via 'File' > 'Options' > 'Add-ins' to isolate the culprit.

Add-in Identification: COM add-ins are the most common cause of formatting retention issues. Focus on disabling these first if Safe Mode resolves the problem.

Solution 2

Run an Online Repair for Microsoft 365

Use the Windows built-in repair tool to fix underlying Office installation errors that prevent files from saving formatting correctly.

Free Microsoft Office alternative

Experience Hassle-Free Spreadsheet Formatting with WPS Office

If Microsoft 365 continues to struggle with saving your note formatting, consider switching to WPS Office. It provides a lightweight, highly compatible alternative where features like custom note sizes save seamlessly without requiring complex troubleshooting.

1. Download and Install: Download WPS Office for free from the official website and install it on your Windows PC.
2. Open your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file without worrying about compatibility issues.
3. Manage Notes Seamlessly: Right-click any cell to insert or edit a note, resize it by dragging the corners, and save the file to lock in your changes permanently.

Fully compatible with Microsoft Excel (.xlsx) formats and features.Notes and comments retain custom sizes and formatting reliably upon saving.Lightweight design ensures smooth performance without frequent repair needs.Familiar, easy-to-use tabbed interface allows for quick and seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel notes keep reverting to their original size?

This issue is typically caused by a glitch in the Microsoft 365 application, conflicting third-party Excel add-ins, or minor file corruption preventing formatting changes from being fully committed to the file during saving.

Can I set a default size for all new Excel notes?

Microsoft Excel does not offer a native setting to globally change the default size of all newly created notes. Each note must be manually resized by selecting it and dragging the corner or edge handles.

What is the difference between Notes and Comments in Excel?

In modern versions of Microsoft 365, 'Comments' are used for threaded conversations where multiple users can reply to one another. 'Notes' are the traditional, static yellow sticky-note style annotations used for leaving simple reminders or context for a cell.

Document & File Issues