Formatting Issues

How to Prevent Excel from Restoring a Default Bottom Border

Natalie Taylor Oct 1, 2026 871 views

Question details

The user wants to stop a default bottom border from automatically reappearing every time they reopen an Excel workbook.

How to Prevent Excel from Restoring a Default Bottom Border

Product: Microsoft Excel
Device & OS: not provided
Scenario: Reopening an Excel workbook where previous border formatting adjustments were made.
Observed behavior: Excel automatically restores a default bottom border to cells upon opening the file, ignoring previous attempts to remove it.

Before you start

Before applying VBA macros to resolve global formatting issues, ensure your workbook is saved in a macro-enabled format (.xlsm) and that you trust the document's source.

Solution 1

Check and Update Workbook Cell Styles

Excel may reapply default styles upon opening. Modifying the base Normal cell style can prevent unwanted bottom borders from appearing.

Sometimes, the global default style in a specific workbook becomes corrupted or altered. Correcting the primary cell style can resolve the issue without needing to write code.

Open Cell Styles

Navigate to the Home tab on the Excel ribbon and locate the Styles group. Click on Cell Styles.

Modify the Normal Style

Right-click on the 'Normal' style and select Modify from the context menu.

Adjust Format Settings

Click the Format button, go to the Borders tab, and ensure that no borders (specifically the bottom border) are selected. Click OK to apply the changes.

Solution 2Recommended

Use a VBA Macro to Remove Borders Automatically

Add a Workbook_Open event macro to clear all borders across all worksheets every time the file is opened.

How to manage cell borders and macros seamlessly in WPS Spreadsheet

WPS Spreadsheet provides robust formatting tools and full VBA macro support, making it easy to fix stubborn border issues without struggling through complex global settings.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your affected spreadsheet document.
2. Clear borders manually: Select the affected cells, navigate to the Home tab, and use the 'Borders' dropdown menu to select 'No Border'.
3. Automate with VBA: If you prefer automation, navigate to the Developer tab and click 'VBA Editor' to input the Workbook_Open macro.
4. Save your work: Save the file as a Macro-Enabled Workbook (.xlsm) to ensure your formatting scripts run automatically on your next launch.

Fully compatible with Microsoft Excel format files (.xlsx, .xlsm)Intuitive cell style management to prevent unwanted default formattingNative VBA Editor available for running Workbook_Open macros flawlesslyLightweight architecture ensuring fast loading and editing

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep changing my cell formats?

Excel sometimes automatically applies default Cell Styles (like the 'Normal' style) across the workbook. If this base style is modified or corrupted, it can unexpectedly reapply formats such as bottom borders.

Will the VBA macro remove borders I want to keep?

Yes, the specific xlNone macro provided clears all line styles across all cells in the workbook. If you need to keep specific borders, you will need to modify the VBA code to target only specific ranges rather than entire worksheets.

How do I ensure my macro saves properly?

You must go to File > Save As and choose 'Excel Macro-Enabled Workbook (*.xlsm)' from the file format dropdown. Macros will be stripped out and lost if you save the file in the standard .xlsx format.

Document & File Issues