How to Merge Cells in Excel

By eHow Computers Editor

Rate: (1 Ratings)

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.

Flag Article

Instructions

Difficulty: Easy

Things You’ll Need:

Microsoft Excel 2003

Step1

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.

Step2

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.

Step3

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.

Step4

Click the "Alignment" tab at the top of the "Format Cells" dialog box to show the alignment options for the currently selected cells.

Step5

Use your mouse to click the check box before the option "Merge Cells" under the "Text control" section of the "Format Cells" dialog box.

Step6

Press the "OK" button with your mouse to close the "Format Cells" dialog box and merge the selected cells together in your Excel spreadsheet.

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.