Reply to thread

Message

[QUOTE="BoniM, post: 3760986"]
Received email request for further explanation (from lurker) sharing here as
well:

Say cells A1 and B3 are unlocked and the range D2:D4 has been merged and
also has the locked property turned off.  Protecting the sheet and unchecking
select locked cells, allows the user to only select unlocked cellsâ€¦ which
means tab will move them to the next unlocked cell on the current row or, if
there are no more on this row, the first unlocked cell on the next row.  With
the cells listed above, a tab from A1 will move you to D2, a tab from D2 will
move you to B3, and a tab from B3 will move you to D3â€¦ part of the merged
range â€“ but still technically the next unlocked cell.  Of course, once the
selection gets there, itâ€™s really back in cell D2 - because of the merge  -
and a tab from cell D2 will move the selection to B3 and then youâ€™re stuck in
a loop and it never makes it back to A1. (Though arrow keys and the mouse
will still get you outâ€¦)

Just one more reason to avoid merging cells!
[/QUOTE]

Verification