Excel shortcuts

How to Use the Excel Shortcut to Merge Cells

If you work with data in Microsoft Excel, you may find yourself in a situation where you need to merge two or more cells into a single cell. For example, you may have a column of data that contains first and last names, and you want to merge those into a single cell so that you can sort the data by last name. Or, you may have a column of data that contains street addresses, and you want to merge those into a single cell so that you can sort the data by zip code. Whatever the reason, if you need to merge cells in Excel, there is a shortcut that you can use to do so.

To use the shortcut to merge cells in Excel, first select the cells that you want to merge. Then, press and hold down the Ctrl key on your keyboard, and while you have the Ctrl key pressed, press the + key (which is located on the same key as the = key). This shortcut will merge the selected cells into a single cell.

If you want to un-merge cells that have been merged using this shortcut, simply select the merged cell, and then press and hold down the Ctrl key on your keyboard, and while you have the Ctrl key pressed, press the - key (which is located on the same key as the + key). This shortcut will un-merge the selected cells.

That's all there is to using the shortcut to merge cells in Excel!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.