Merging multiple cells was introduced in Excel 97.

From that version to current version(2003), merging cells with data will retain
only the data from the top left cell.

Also, merging multiple cells does not allow any more data to be placed in that
merged cell.

All you have done is create one visually larger cell with the same limitations
as any one of the original cells.


Gord Dibben MS Excel MVP

On Mon, 24 Apr 2006 14:14:02 -0700, gammellm
wrote:

I've created a form with some cells merged together to provide enough room
for the data entry. However when I used the Wizard Template it only wants to
take information from one of however many cells I have merged together. I
don't remember having this problem before I upgraded to 2003... Any
suggestions? Other than starting over!