Tuesday, May 15, 2012

How to Merge Cells in Excel


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.

Blogger news