Results 1 to 1 of 1

Merge cells and Split Merge Cells in Excel 2010

This is a discussion on Merge cells and Split Merge Cells in Excel 2010 within the Applications forums, part of the Tutorials category; Merge cells and Split Merge Cells in Excel 2010 You cannot split any individual cell in Excel worksheet, but you ...

  1. #1
    Senior Member
    Join Date
    Jun 2010
    Posts
    870

    Default Merge cells and Split Merge Cells in Excel 2010

    Merge cells and Split Merge Cells in Excel 2010


    You cannot split any individual cell in Excel worksheet, but you can have the individual cell appear as a single cell that is split and merged by the cells placed just above. For instance, if you want to split the cell H2 into three chunks that will appear in an adjacent manner under the cell H1 (cell H1 used for Heading), it will not be possible to split the cell H2 but, you can gain the same split effect by merging the cells H1, I1 and J1 into a singe cell. Then you can enter the data in respected cells H2, I2 and J2 which will appear as cells placed under a large cell that is acting as a cell Heading.


    If you have merged multiple adjacent Vertical or Horizontal cells, the merged cell will appear as a large single cell that will be displayed across multiple rows or columns. Below is a tutorial that will guide you on the usage of Merge cells feature in Microsoft Excel 2010 Application.


    How to Merge Cells

    1) Select two adjacent cells which you intend to merge.


    Figure 1



    2) Click on the “Home” tab and under the Home tab, in the ‘Alignment’ category, click on the ‘Merge and Center’ icon.


    Figure 2



    3) Then choose the option that says ‘Merge and Center’ from the drop down list of the Merge and center icon in order to merge the cells.


    Figure 3



    4) Now the selected cells would be merged across a column or a row and the contents will be merged and appear at the center of the cell that is merged.


    Figure 4



    5) If you do not want the contents to be merged at the center, you can choose it to be merged across by selecting the option ‘Merge Across’ or ‘Merge Cells’.


    Figure 5



    6) To split a merged cell, select the merged cell and then click on the “Home” tab and in the ‘Alignment’ category, click on the ‘Merge & Center’ icon and then choose the option ‘Merge and Center’ from the drop down list,


    Figure 6



    7) Now you can observe that the merged cell has split into individual cells.

    8) In case, if you want to find the Merge cells in your excel worksheet, you can use the ‘Find & Select’ button.

    9) To do so, click on the ‘Find & select’ button and then in the ‘Find and Replace’ window thus opened, click on the ‘Options’ tab and then on ‘Format’ tab.


    Figure 7



    10) Now in the new window thus opened, under the ‘Alignment’ tab, select the check box that says ‘Merge cells’ and click ‘OK’.


    Figure 8



    So, this is all about the Merge cells and Split Merge cells features in MS Excel 2010 Application.

    Read Other Applications
    Last edited by jagadish; 08-19-2010 at 05:59 PM.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •