How to Merge Cells in Excel
While you are working within a Microsoft Excel spreadsheet you may find the need to merge two or more cells together to form one cell. This is often done if you need to add a heading or title to a row, column or section of your Excel spreadsheet. Follow the steps below to find out how to merge cells in your Excel spreadsheet.
Other People Are Reading
Instructions
-
-
1
Start Microsoft Excel, and open the spreadsheet that contains the multiple cells you would like to merge into one cell. If you like, you can just start a new spreadsheet to perform the task of merging cells.
-
2
Select the cells that you would like to merge by clicking on the first cell with your mouse, holding down your left mouse button and dragging until all of the cells you want to merge are highlighted.
-
-
3
Right-click to bring up the Excel menu and click on "Format Cells..." to open the "Format Cells" dialog box. In the "Format Cells" dialog box you can change all of the formatting options related to the cells and text you have within the cells, including the option of merging cells together.
-
4
Click the "Alignment" tab at the top of the "Format Cells" dialog box to show the alignment options for the currently selected cells.
-
5
Use your mouse to click the check box before the option "Merge Cells" under the "Text control" section of the "Format Cells" dialog box.
-
6
Press the "OK" button with your mouse to close the "Format Cells" dialog box and merge the selected cells together in your Excel spreadsheet.
-
1
Tips & Warnings
Quickly merge together two or more cells by highlighting the cells and clicking the "Merge and Center" button located on the Formatting toolbar within Microsoft Excel.
You can only merge adjacent cells together in an Excel spreadsheet.
