Merging 2 worksheets (newbie)

[Guest]

I'm trying to merge two mailing lists from separate worksheets, and keep
getting the message that the cells must be identical. All the cells on both
worksheets are the same size, the fields are named the same, but of course
the content is different--so I'm not sure what the program's asking for. Can
this not be done as a simple cut and paste?

 

[Max]

Think you're hitting this error
because there's some merged* cells

*A formatting "feature" which could result in problems downstream, and
should be avoided where possible,
going by posts by experienced folks here

Try this on a *test* copy of your file
to remove the merged cells from each sheet

Press CTRL+A to select the entire sheet
Click Format > Cells > Alignment tab
Click the box for "Merge cells" until it's totally cleared
Click OK
(This will remove all the merged cells in the sheet,
wherever they are)

Now .. re-try what you were trying to do earlier

Instead of merging cells, an alternative way to
stretch a text label across several cells would be
via selecting:
"Centre across selection" under the Horizontal box
in the Alignment tab