Excel shortcuts

How to use the merge cells shortcut in Excel

If you work with data in Microsoft Excel, you may find yourself in a situation where you need to merge two or more cells together. This can be a tedious process if you do it manually, but there is a shortcut that can save you time.

To use the merge cells shortcut, first select the cells that you want to merge. Then, press and hold the Ctrl key on your keyboard. While you have the Ctrl key pressed, press the + key (on the main keyboard, not the numeric keypad). This will merge the selected cells together.

If you want to unmerge cells that have been merged together, select the merged cells and press the Ctrl key and the - key (on the main keyboard, not the numeric keypad).

You can also use the merge cells shortcut to quickly split merged cells. To do this, select the merged cells and press the Ctrl key and the / key (on the main keyboard, not the numeric keypad).

The merge cells shortcut is a quick and easy way to save time when working with data in Excel. Give it a try the next time you need to merge or split cells in your worksheet.

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.