Center Across Selection (Stop Merging Cells)

Merged cells look tidy and quietly break everything — sorting, filtering, copy-paste, and formulas. Center Across Selection gives you the same centered heading without any of that damage. Here is how to switch.

By the Quiriz Team · Published July 28, 2026 · 4 min read

The quick answer: select the cells, press Ctrl + 1, go to the Alignment tab, and set Horizontal → Center Across Selection. You get a heading centered across several columns that looks merged but isn't — so nothing breaks.

Why merged cells cause trouble

Merging looks harmless: you select a few cells, click Merge & Center, and your title sits neatly over the table. The cost shows up later. You can't sort or filter a table that contains merged cells without an error. Copy and paste over the range misbehaves. Formulas and range references that touch the merged area return surprises. Half the "why won't my sheet sort?" problems trace back to a merged cell someone added months ago.

Center Across Selection, step by step

Select the range you want the heading centered over — the cell holding the text plus the empty cells beside it, say A1:E1. Press Ctrl + 1 to open Format Cells and switch to the Alignment tab. Under Horizontal, choose Center Across Selection, then OK. The text centers across all five columns, but every cell stays independent.

Confirm nothing is merged

Click across the range afterward. The heading text still lives only in the left-most cell — the others are genuinely empty and selectable. That's the whole point: the display is centered, but the grid underneath is untouched, so sorting, filtering, and formulas all keep working.

There are a few cases where you still need a real merge — for example, a printed cover sheet where a block must span rows. For anything in a working data table, Center Across Selection is the safer default.

Clean tables are easier to work with

Un-merged, consistently shaped tables aren't just easier to sort and filter — they're easier for anything to read, including tools that answer questions about your data. If you ever point Quiriz at a spreadsheet to ask it questions, a clean table with no merged cells gives you far more reliable answers than a heavily formatted one.

Ask your clean spreadsheet a question

Once your data is tidy, ask a question about it in plain English and get the answer back in seconds. Free to start.

Try Quiriz free →

Frequently asked questions

What is the difference between Merge Cells and Center Across Selection?

Merge Cells turns several cells into one, which breaks sorting, filtering, copy-paste, and many formulas over that range. Center Across Selection only changes how the text is displayed — it centers the value of the left-most cell across the range while every cell stays separate and fully usable.

Why should I avoid merged cells in Excel?

Merged cells stop you from sorting or filtering a table, cause "This won't work with merged cells" errors, break paste operations, and make range references behave unexpectedly. They are one of the most common causes of a spreadsheet that suddenly won't sort or filter.

How do I center a title across columns without merging?

Select the title cell and the empty cells to its right, press Ctrl+1, go to Alignment, and set Horizontal to Center Across Selection. The title appears centered over all those columns, but no cells are merged.

Does Center Across Selection work vertically?

No. Center Across Selection only centers horizontally across columns. For a heading that spans rows, you generally need a different layout, since there is no vertical equivalent.