docs / articles / Excel Merge Cells Shortcuts: Master These Keyboard Commands

Excel Merge Cells Shortcuts: Master These Keyboard Commands

Sara Jul 09, 2026 2026-07-09 04:40:45

In the fast-paced world of data analysis and management, every shortcut can make a significant difference in productivity. One such time-saving feature in Microsoft Excel is the ability to merge cells, allowing you to combine data from multiple cells into one. But did you know there are keyboard shortcuts that can streamline this process even further? Let's delve into the world of Excel shortcuts and explore how you can merge cells with ease.

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

Before we dive into the shortcuts, let's quickly recap why you might want to merge cells. Merging cells is particularly useful when you want to display a single value across multiple columns or rows, or when you want to create a header that spans multiple cells. Now, let's get started with the shortcuts.

Merge cells the proper way.
Merge cells the proper way.

Merging Cells in Excel

To merge cells in Excel, you first need to select the cells you want to combine. Once selected, you can use the following shortcut to merge them:

Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips

Shortcut for Merging Selected Cells

Press Alt + Merge Center (on Windows) or Option + Command + M (on Mac). This will merge the selected cells into one, with the content of the top-left cell taking precedence.

the excel win and mac shortcut keys are shown in blue, green, and white
the excel win and mac shortcut keys are shown in blue, green, and white

However, this shortcut only merges the selected cells horizontally. If you want to merge cells vertically, you'll need to use a different method. Let's explore that next.

Merging Cells Vertically

To merge cells vertically, you'll first need to select the cells you want to combine, then use the following shortcut:

an excel shortcut key is shown in green and white
an excel shortcut key is shown in green and white

Press Alt + Merge <Down Arrow> (on Windows) or Option + Command + M + Down Arrow (on Mac). This will merge the selected cells vertically, with the content of the first cell taking precedence.

Now that we've covered the basics of merging cells, let's look at how to unmerge cells when you need to separate them again.

Unmerging Cells in Excel

173K views | Reel by Harkesh Kumar
173K views | Reel by Harkesh Kumar

Sometimes, you might need to unmerge cells to separate their contents. Excel provides a shortcut for this as well:

Shortcut for Unmerging Cells

Computer tricks😉
Computer tricks😉
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
Excel shortcut ...✅
Excel shortcut ...✅
Microsoft Excel Shortcut key
Microsoft Excel Shortcut key
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
25 Excel Shortcuts to Boost Your Productivity – Master Keyboard Shortcuts for Efficiency
25 Excel Shortcuts to Boost Your Productivity – Master Keyboard Shortcuts for Efficiency
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
DON’T Merge Cells in Excel – Do This Instead
DON’T Merge Cells in Excel – Do This Instead
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
excel useful shortcuts
excel useful shortcuts
How to Merge Two Cells in Excel without Losing Any Data
How to Merge Two Cells in Excel without Losing Any Data
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
23 Excel important Shortcut Key's
23 Excel important Shortcut Key's
Top 20 Advanced Excel Shortcut Keys You Should Know
Top 20 Advanced Excel Shortcut Keys You Should Know
Credits to Josh Aharonoff, CPA Follow him for more content. | Excel for CFOs
Credits to Josh Aharonoff, CPA Follow him for more content. | Excel for CFOs
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
the ultimate guide to advanced excel and keywords tips & tricks for beginners
the ultimate guide to advanced excel and keywords tips & tricks for beginners
ms excel shortcut keys part 2 - screenshote for windows and macs
ms excel shortcut keys part 2 - screenshote for windows and macs
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!

Select the merged cell, then press Ctrl + Shift + U (on Windows) or Command + Shift + U (on Mac). This will unmerge the cell, restoring it to its original size and splitting the content across the new cells.

Remember, the content of the merged cell will be distributed across the new cells based on the original cell size. If you want to preserve the content of each cell, you'll need to manually adjust the content after unmerging.

In conclusion, mastering these shortcuts can significantly speed up your workflow in Excel. Whether you're merging cells to create a header or unmerging them to separate content, these keyboard shortcuts can help you work more efficiently. So, start practicing these shortcuts today and watch your productivity soar!