merge data problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top