Tips & Tricks - 2026-05-12
Merge Cells in Excel: When to Use It and Avoid It
Learn how to merge cells in Excel, when merged cells are useful, why they can break sorting and filtering, and better alternatives.
What Merge Cells Does
- Merge Cells combines selected cells into one larger cell. It is often used for titles, headers, and printable forms. Use: Home -> Merge & Center
When Merge Cells Is Useful
- Merged cells can be fine for: Report titles Printable forms Presentation-style sheets Labels outside data tables
Why Merged Cells Cause Problems
- Merged cells can interfere with: Sorting Filtering Copying and pasting Pivot Tables Table ranges Formula fills Avoid merged cells inside datasets.
Better Alternative: Center Across Selection
- For titles, use Center Across Selection instead of Merge & Center. Open Format Cells -> Alignment -> Horizontal -> Center Across Selection.
Related Guides
- How to Sort in Excel How to Filter in Excel Excel Tables Benefits Wrap Text in Excel
Quick win checklist
- Try the shortcut or setting on a copy of your file first. Pin the technique to your Quick Access Toolbar if you will use it daily. Pair productivity tips with Excel Tables and named ranges for fewer broken references. Explore: Tips archive · Keyboard shortcuts guide
Frequently asked questions
- Why should I avoid merged cells in Excel tables? Merged cells can break sorting, filtering, copying, formulas, and Pivot Table source ranges.
- What is better than Merge & Center? Center Across Selection is often better for titles because it looks similar without merging cells.
- How do I remember this Excel tip? Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.
- Will this tip work on Mac Excel? Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.