Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
The most common reason to merge cells is for formatting and centering headings. This guide will show you how to merge cells in Excel, even though it is highly recommended that you don’t merge them unless you absolutely need to. As an alternative, we recommend using the Center Across Selection feature. Learn with video instruction in CFI’s Free Excel Crash Course!
How to Merge Cells in Excel
Follow the steps below to learn how to easily combine multiple cells in an Excel spreadsheet. Use the screenshots as a guide and then try it on your own!
Select the cells you want to merge. Highlight them with your mouse or by starting in one cell, holding Shift, then using the arrows to select to the end.
On the Home Ribbon, select the Format Cells button, or press the keyboard shortcut Ctrl + 1 to open the Format Cells dialogue box.
Inside the Format Cells menu, click on the Alignment tab and tick the box that says Merge Cells.
Click center to place the title in the center of the merged cells and set a background color to make the title really stand out.
An Alternative to Merge Cells in Excel – Center Across Selection
Merging cells is not recommended because it interferes with actions you may wish to take later while building your financial model. For example, if you want to insert or delete columns across the middle of merged cells, you will not be able to.
You can achieve the same formatting outcome as merging cells by using the Center Across Selection function.
Follow the steps below to perform the action yourself.
Select the cells you want to center using the mouse or holding the Shift key and using the keyboard arrows.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.