Excel shortcuts

Excel Shortcut to Merge Cells: How to Use

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 one. For example, you may have a list of names in one column and a list of addresses in another column, and you want to merge them into one column. Or, you may have a list of product names in one column and a list of prices in another column, and you want to merge them into one column. Whatever the reason, if you need to merge cells in Excel, there is a shortcut that you can use to do so.

To merge cells in Excel, first select the cells that you want to merge. Then, press the Alt + = keys on your keyboard. This shortcut will merge the selected cells into one cell. Keep in mind that this shortcut will only work if the cells you are merging are adjacent to each other. If the cells are not adjacent, you will need to use the Merge & Center command on the Home tab of the ribbon.

Once you have merged the cells, you may want to center the text within the merged cell. To do this, select the merged cell and then click the Center button on the Home tab of the ribbon. You can also use the shortcut Alt + H + C to center the text within the merged cell.

If you need to unmerge cells that have been merged, simply select the merged cell and press the Alt + = keys on your keyboard. This shortcut will unmerge the cells and return them to their previous state.

As you can see, the shortcut to merge cells in Excel is very simple to use. Just remember the shortcut keys: Alt + = to merge and Alt + = to unmerge. With this shortcut, you can quickly and easily merge and unmerge 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.