How to merge cells with data in Excel
By
SpreadCheaters
You can watch a video tutorial here.
When cells are merged in Excel, only the data in the top left cell is retained and the data in the other cells are lost. If you need only the top left data, then it is okay to proceed with merging. This solution looks at how to retain the data when merging cells.
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
Step 4 – Navigate to the Merge menu
– Select Home > Alignment > Merge & Center
Step 5 – Merge the cells
– Select Merge & Center
– An error message with be displayed
– Click OK
Step 6 – Align the data
– With the Merge & Center option, the data from the top row is positioned at the bottom of the cell, in the center
– With the Merge Cells option, the data from the top row is positioned at the bottom of the cell, aligned to the left
– Use any of the options in the Alignment section to align the data in the cell.
– This action can be reversed using the Unmerge Cells option.
