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?

Hi
AFAIK this always worked this way. If you want to combine this data
you'll need VBA

--
Regards
Frank Kabel
Frankfurt, Germany

"ZCDeVico" schrieb im Newsbeitrag
...
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?