How to make two cells into one in Excel
By
SpreadCheaters
You can watch a video tutorial here.
In Excel, to make two cells into one you can merge them. This can be done across rows or columns. The row/column format remains intact but the two cells are made into one. When formatting tables in Excel, you may need to merge cells to properly label the data and to make it look neater. For example, you have a heading that applies to two columns and you need it to span both columns so that it correctly conveys the information to the reader. In this case, you need to merge the cells.
Step 1 – Merge two cells across columns
– Ensure that the heading is in the left cell
Note: Merging cells retain the data only in the top left corner of the selected range. Data in other cells will be lost
– Select the cells
– Go to Home > Alignment
– Under Merge & Center, click Merge & Center
Step 2 – Merge two cells across rows
– Ensure that the heading is in the top cell
Note: Merging cells retain the data only in the top left corner of the selected range. Data in other cells will be lost
– Select the cells
– Go to Home > Alignment
– Under Merge & Center, click Merge Cells
Step 3 – Check the result
– Two cells are merged across columns for the ‘Sales’ header
– Two calls are merged across rows for the ‘Region number’
