I have a protected worksheet with several sections of merged cells. When
selecting cells prior to protecting I select in the order I want the user to
tab.

When leaving the first merged cell by tabbing, and the user is moved to the
next cell tabbing from that cell bring you back to the previous merged cell.
I am thinking that Excel thinks it needs to go to next row of the merged cell.

Can I get over this hurddle and convince Excel to continue moving forward?

Easy workaround.

Remove the merged cells which cause no end of problems and limit
functionality...............one of which you just discovered.

Merged cells have their place.

One place I can think of is for presentation only..........no other
manipulations or functions required on that sheet.

Maybe "center across selection" will give you the look you want and still
allow full functionality.


Gord Dibben MS Excel MVP

On Fri, 18 Dec 2009 12:26:02 -0800, rvtrails
wrote:

I have a protected worksheet with several sections of merged cells. When
selecting cells prior to protecting I select in the order I want the user to
tab.

When leaving the first merged cell by tabbing, and the user is moved to the
next cell tabbing from that cell bring you back to the previous merged cell.
I am thinking that Excel thinks it needs to go to next row of the merged cell.

Can I get over this hurddle and convince Excel to continue moving forward?

One more tip to make a group of cells "look" merged.

Place a border around the group and set the fill color to white, which
erases the gridlines in that range.


Gord

On Sat, 19 Dec 2009 12:08:00 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Easy workaround.

Remove the merged cells which cause no end of problems and limit
functionality...............one of which you just discovered.

Merged cells have their place.

One place I can think of is for presentation only..........no other
manipulations or functions required on that sheet.

Maybe "center across selection" will give you the look you want and still
allow full functionality.


Gord Dibben MS Excel MVP

On Fri, 18 Dec 2009 12:26:02 -0800, rvtrails
wrote:

I have a protected worksheet with several sections of merged cells. When
selecting cells prior to protecting I select in the order I want the user to
tab.

When leaving the first merged cell by tabbing, and the user is moved to the
next cell tabbing from that cell bring you back to the previous merged cell.
I am thinking that Excel thinks it needs to go to next row of the merged cell.

Can I get over this hurddle and convince Excel to continue moving forward?