How To: Merge & unmerge cells in Excel

In this software video tutorial you will learn how to merge and unmerge cells in Excel. A cell in an Excel spread sheet is assigned a row and a column number. You will mostly need to merge cells when you are trying to create headers that span across two or more cells. For this select the cells that you want to merge by clicking and holding down the left mouse key on the first cell and then dragging it across the other cells that you want to merge. Then go to the 'home' tab, click on 'alignment' and select the 'merge cells' or 'merge and center' button as required. And the selected cells will be merged.