Image: Richard Drury via Getty Images.
To format your Excel spreadsheets, nothing could be simpler than merging certain cells. This fusion of cells can be done vertically or horizontally.
This feature can be very useful for cells where you write a header, title or category, for example. Once the grouping is complete, the new cell functions as an individual cell.
The following example will be given on Microsoft Excel, but this functionality exists in other similar software, such as Google Sheets. However, the procedure may be slightly different.
How to merge cells in Excel
1. Select the cells to merge
When you merge several cells, only the information contained in the first one (the top one vertically, the left one horizontally) will be kept. If the other cells also contain data, they will be cleared in the process. So remember to check this information before you start.
Next, select the cells you want to merge, vertically or horizontally (or both).
Screenshot by Maria Diaz/ZDNET.
2. Merge selected cells
On the taskbar, click Merge and Center. Your cells are then grouped into one.
Screenshot by Maria Diaz/ZDNET.
How to separate merged cells?
Select the cell in question, then click again Merge and Center.
The cells that had been grouped together are then automatically separated. On the right, a drop-down menu also offers you Unmerge cells.
How to merge an entire row or column?
Select the entire row or column, then click Merge and Center.
Source: ZDNet.com