When I tab after entering data in a cell, the tab jumps to another page in
the same sheet instead of tabbing to the next cell. And when I hit return to
go back to the first cell in the next column, it simply goes down one cell in
the same column.

Not sure what you mean by another page in a sheet, but you seem to be
describing what normally happens...

Perhaps you're wanting to setup a protected sheet, with some cells
unprotected, so that when you press tab/enter you skip to the unprotected
cells, as opposed to the normal movement?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"B" wrote:

When I tab after entering data in a cell, the tab jumps to another page in
the same sheet instead of tabbing to the next cell. And when I hit return to
go back to the first cell in the next column, it simply goes down one cell in
the same column.

For versions earlier than 2007

ToolsOptionsTransition.

Uncheck all the Lotus Transition Options

Your Tab key will now work as it should.


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 09:04:01 -0800, B wrote:

When I tab after entering data in a cell, the tab jumps to another page in
the same sheet instead of tabbing to the next cell. And when I hit return to
go back to the first cell in the next column, it simply goes down one cell in
the same column.