How to Merge the Cells in excel?
In excel there is a wonderful option where it actually merges the cells. This option is useful when you want to create a Column heading and under which there are multiple sub headings.
Lets see the below explanation how to works.
We want to select excel cells "A1" , "B1" and "C1" as single cell which is used for main heading under which "A2", "B2" and "C2" are sub headings of the Column then we need to do as below.
Select "A1" , "B1" and "C1" and choose the option in red box below "Merge and Center". This option allows you to Merge the multiple sequential cells as a single cell.
When you enter the content in the cell "A1" and select the cells "A1", "B1" and "C1" and click on the option "Merge & Center" then it will automatically align the contents to the center. Now you can see the Column heading is big and under which you can create Sub headings as shown in above screen shot.
Merging options available in System:
In excel there is a wonderful option where it actually merges the cells. This option is useful when you want to create a Column heading and under which there are multiple sub headings.
Lets see the below explanation how to works.
We want to select excel cells "A1" , "B1" and "C1" as single cell which is used for main heading under which "A2", "B2" and "C2" are sub headings of the Column then we need to do as below.
Select "A1" , "B1" and "C1" and choose the option in red box below "Merge and Center". This option allows you to Merge the multiple sequential cells as a single cell.
Merging options available in System:
No comments:
Post a Comment