How to merge cells in Excel and keep all data

You can watch a video tutorial here.

Merging cells in Excel is most often used when formatting tables, to make the table more presentable. By merging cells you can make it easier for the reader to understand the data that is being presented. When merging cells, only the data in the topmost cell on the left is retained and the values in the other cells are lost. In most cases, the data needs to be kept and there is a workaround in Excel.

Step 1 – Open the clipboard

– Go to the Home menu
– Open the Clipboard

Step 2 – Copy the data

– Select the rows to be merged and click Ctrl+C
– The data will be copied onto the clipboard

Step 3 – Paste the data into the top cell

– Double-click on the top cell or place the cursor on the cell and click F2
– Delete the data in the cell
– Click on the item in the clipboard
– The data will be pasted into the cell
– Press Enter

Step 4 – Navigate to the Merge menu

– Select the cells to be merged
– Got to Home > Alignment
– Expand the Merge & Center menu
– Choose Merge & Center

Step 5 – Acknowledge the warning

– A warning will be displayed
– Click OK

Step 6 – Check the result

– The cells are merged
– The data is retained