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!

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!

Yes, I realize the concept of the merged cell. What I'm wondering is why the
wizard template was willing to work with merged cells in my previous word
version and if I can get it to work with merged cells in excel 2003.

"Gord Dibben" wrote:

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!

Have not worked with the Wizard Template so can't address any problems
associated with that particular feature.

Hang in there, someone will have an idea.


Gord



On Tue, 25 Apr 2006 10:49:03 -0700, gammell
wrote:

Yes, I realize the concept of the merged cell. What I'm wondering is why the
wizard template was willing to work with merged cells in my previous word
version and if I can get it to work with merged cells in excel 2003.

"Gord Dibben" wrote:

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!