This tutorial is about to merge the cells in Microsoft excel for this see spreadsheet, shown below:

Simple spreadsheet in Microsoft Excel

Simple spreadsheet in Microsoft Excel

 

Look at the row 1, you will see that the “Customer Bill” heading stretches across three cells. This is not three different separated cells but cell B1, C1 and D1 were merged.

To merge the cells higlighted the cell B1, C1 and D1 and then find the alignment panel Excel ribbon, then locate the “Merge and Center” option:

Alignment Panel in Microsoft Excel

Alignment Panel in Microsoft Excel

 

Click on the black down arrow on the merge and center option to see the following option:

Merge and center option in Microsoft Excel

Merge and center option in Microsoft Excel

 

Click on the “merge and center” and three cells becomes one and text will be written in the center of the cell. Now practice on Microsoft Excel and increase your skills.

Please follow and like us:

admin

Leave a Reply

Your email address will not be published. Required fields are marked *