Formatting Issues

How to Disable the Warning Message When Merging Cells in Excel

Maira Mehtab Sep 27, 2026 869 views

Question details

The user wants to know how to stop the warning prompt from appearing every time they merge cells containing data in Microsoft Excel.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Merging multiple cells that already contain data.
Observed behavior: Excel displays a mandatory warning prompt stating that merging cells only keeps the upper-left cell's value and discards other values.

Before you start

Before attempting to bypass the cell merge warning, ensure that you do not need the data in the secondary cells, as merging will permanently delete all values except the one in the upper-left position.

Solution 1Recommended

Use VBA to Suppress the Merge Cells Warning

Since Excel lacks a built-in UI toggle to disable this warning, you can use a VBA macro to temporarily suppress alerts when running automated tasks.

Microsoft Excel does not offer a standard settings toggle to permanently disable the cell merge warning for manual operations. However, if you are automating formatting tasks with a macro, you can use the Application.DisplayAlerts property in VBA to hide this prompt.

Open the VBA Editor

Press Alt + F11 on your keyboard to open the Microsoft Visual Basic for Applications window.

Insert a New Module

Click on 'Insert' in the top menu bar and select 'Module' to create a blank scripting area.

Disable Alerts in Your Code

Immediately before your cell merging command in the script, insert the line: Application.DisplayAlerts = False.

Re-enable Alerts

After the merge code executes, it is highly recommended to turn alerts back on by adding: Application.DisplayAlerts = True.

Provide Feedback to Microsoft: If this warning is bothersome during manual data entry and you prefer a built-in toggle, submit feedback directly to the Excel development team requesting this feature.

Free Microsoft Office alternative

Switch to WPS Office for Seamless Spreadsheet Management

If unresolved Excel limitations are slowing down your workflow, consider switching to WPS Office. It is a highly compatible, free alternative that offers all the robust spreadsheet features you need with a familiar, easy-to-use interface.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks with perfect formatting retention.
3. Manage Data Efficiently: Use intuitive built-in tools to merge, format, and organize your data seamlessly.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Lightweight installation footprint and fast startup speed.Familiar tabbed interface requiring zero learning curve for Excel users.Rich formatting and data processing tools available for free.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel always show a warning when merging cells?

Excel displays this warning as a safeguard to prevent accidental data loss. Because the standard merge function only retains the data from the upper-left cell and deletes everything else in the selection, the prompt ensures users are aware of the deletion.

Can I merge multiple cells without losing data in Excel?

Standard merging will always discard extra data. To combine data from multiple cells into one without losing anything, use the CONCATENATE function, the TEXTJOIN function, or the '&' operator to join the text first, and then merge the cells if necessary.

Is there a Windows Registry hack to disable the merge warning in Excel?

No, there is no known registry key or hidden general Excel setting that can permanently disable the cell merge warning for manual user operations.

Document & File Issues