How To Merge Cells In Excel


  • Lets start with the example. Below picture shows text in one of the box.



  • To merge it across the whole length of the text, First select the whole text by dragging the box from right corner until the length of text as shown below.



  • Then look for the option "Merge & Center" Under Home menu.



  • Under Merge & Center click the option "Merge & Center"



  • You would see that all the cells are merged like as shown below...