In an older version of excel, I could highlight a number of cells (let's say
that I highlighted 3 rows and 3 columns) - then click merge - then all of my
data (that was in those 3 rows and 3 columns) would automatically show up in
my one merged-cell. When I try this now, I get a box stating that all of my
data (except the data from the top left box) will be lost in the merge. If I
do it anyway - they are correct - everything is lost except what was in the
top left cell.
How can I do what I used to be able to do?