how to use merge and center in excel 2007

If you don’t want any separator, you can simply leave it out and use the formula =CONCATENATE(A1,B1).Īlternatively, you can use any other separator such as comma or semi-colon. Here we are combining the cells A1 and B1 and have a space character as the separator.

For example, in the above case, enter the following formula in cell C1: =CONCATENATE(A1,” “,B1) If you don’t want to lose the text in from cells getting merged, use the CONCATENATE formula. Merge Cells in Excel Without Losing the Data The Benefit of Not Merging Cells in Excel.Merge Cells in Excel Without Losing the Data.Press the “U” keyboard key, to unmerge those already merged cells.The “M” keyboard key is the shortcut to merge cells in Excel without a centered alignment.Press the “C” keyboard key, is the shortcut to merge cells in Excel after selecting them.Press the “A” key to merge cells within a separate individual row.We can make use of any of these keyboard shortcuts to merge cells in Excel:.Then press the “M” (keyboard shortcut) which enables the Excel “Merge & Center” option.įigure 6. Press the “ALT+H” keyboard keys to select the “Home” tab on the Excel ribbon this will enable the” Home” tab menu of Excel.We start by selecting those cells which we seek to merge and center via shortcut and then press the “ALT” keyboard key which toggles the keyboard commands on an Excel ribbon įigure 5.We will now demonstrate how to use the keyboard shortcut to merge cells in Excel with the following simple steps Note that the text becomes centered in worksheet example above screenshot.

The merge and center function in excel will combine the selected data in one large cell

Click on the “Home” icon, and then go to “Alignment” group, click on the “merge and center” button.

We start by selecting the adjacent cells we want to merge in our worksheet:.

of Merge and Center in Excel How to Use Merge and Center in Excel “Center” implies that it allows for alignment of cell data to be centered.įigure 1.

When cells are merged, only the content of the upper-leftmost cell is preserved. We can combine and center the contents of selected multiple cells inside a new and larger cell with the merge and center shortcut in Excel. How to merge and center cells in Excel – Excelchat

How to use merge and center in excel 2007