Microsoft Excel

Why Excel's Merge and Center Is EVIL (And How to Fix It)

Merge and Center is one of Excel's most misused features. It looks great for formatting headers, but it breaks sorting, filtering, copying, and pasting. In this tutorial, Chris Menard explains exactly why Merge and Center causes problems and shows you the better alternative: Center Across Selection.

Watch the full tutorial:

Why Merge and Center Is a Problem

When you merge cells, Excel combines multiple cells into one. This causes several issues:

Sorting breaks — Excel cannot sort a range that contains merged cells. You'll get an error: "To do this, all the merged cells need to be the same size"
Filtering breaks — Filters skip rows that are part of a merged cell range
Copy and paste breaks — You can't paste data into a range that partially overlaps with merged cells
Data loss risk — When merging cells that contain data, Excel keeps only the upper-left cell's value and deletes everything else

Excel spreadsheet with quarterly sales data for Atlanta, Cleveland, and London using merged cells for city headers — A typical layout using Merge and Center for city headers — looks nice, but causes problems.

How to Find All Merged Cells

If you've inherited a spreadsheet full of merged cells, here's how to find them all:

Press Ctrl+H to open Find and Replace
Click Options to expand the dialog
Click the Format button next to the "Find what" field
Go to the Alignment tab
Check the Merge cells checkbox
Click Find All to see every merged cell in the workbook

Excel Find and Replace dialog with Format options showing Merge cells checkbox — Use Find & Replace with Format options to locate all merged cells in your workbook.

How to Fix It: Unmerge and Use Center Across Selection

The fix is a two-step process:

Step 1: Unmerge All Cells

Select the entire range with merged cells (or press Ctrl+A for the whole sheet)
Go to Home > Merge & Center dropdown
Click Unmerge Cells
The data will now be in the top-left cell of each formerly merged range, with blank cells beside it

Step 2: Apply Center Across Selection

Select the cells you want the text centered across
Press Ctrl+1 to open Format Cells
Go to the Alignment tab
Under Horizontal, choose Center Across Selection
Click OK

The result looks identical to Merge and Center, but the cells remain individual. Sorting, filtering, and copy-paste all work perfectly.

Excel spreadsheet showing sorted data with Center Across Selection applied instead of merge — Center Across Selection achieves the same look without breaking sort and filter.

Want to learn more? Visit courses.chrismenardtraining.com for online training courses.

Delete Blank Columns in Excel: 3 Easy Ways

Blank columns break sorting, filtering, and PivotTables. Remove them with Go To Special, a COUNTA helper row, or Power Query's Column quality view.

Copilot in PowerPoint: Explain vs. Review This Presentation

Copilot in PowerPoint now has two skills with nearly identical names that do very different jobs: Explain this presentation and Review this presentation. One helps you understand a deck someone else made. The other helps you improve a deck you made yourself. If you train people on Copilot, expect questions

Redesign Slides with Copilot's Visualize This Slide Skill in PowerPoint

Use the Visualize this slide skill in Copilot for PowerPoint to turn text-heavy slides into visual layouts. Three examples: bullets, a six-step process, and a timeline.

Copilot Skills in PowerPoint - Live Stream on October 20, 2026

𝗠𝗼𝘀𝘁 𝗣𝗼𝘄𝗲𝗿𝗣𝗼𝗶𝗻𝘁 𝘂𝘀𝗲𝗿𝘀 𝗸𝗻𝗼𝘄 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗰𝗮𝗻 𝗰𝗿𝗲𝗮𝘁𝗲 𝘀𝗹𝗶𝗱𝗲𝘀. 𝗙𝗮𝗿 𝗳𝗲𝘄𝗲𝗿 𝗸𝗻𝗼𝘄 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝟴 𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗦𝗸𝗶𝗹𝗹𝘀 𝘁𝗵𝗮𝘁 𝗰𝗮𝗻 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲𝗹𝘆 𝗰𝗵𝗮𝗻𝗴𝗲 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗯𝘂𝗶𝗹𝗱, 𝗶𝗺𝗽𝗿𝗼𝘃𝗲, 𝗮𝗻𝗱 𝗽𝗿𝗲𝘀𝗲𝗻𝘁 𝗮 𝗱𝗲𝗰𝗸. Join me live on October 20, 2026, at Noon Eastern as I demonstrate each Copilot Skill and show practical ways to use them in your presentations. PDF of the 8 Copilot Skills in Pow