Tabs and returns

  • Thread starter Thread starter B
  • Start date Start date
B

B

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?
 
For versions earlier than 2007

Tools>Options>Transition.

Uncheck all the Lotus Transition Options

Your Tab key will now work as it should.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hit enter in any column and go to next row in first column 3
Using Tab key to jump to specific cell 2
Ribbon Display Options askew?? 6
Tab Key acting up in Excel 2003 1
"Move selection after Enter" 3
Help with tab in Excel 2
Cursor Movement 2
why does tab button jump pages in Excel instead of cells? 1

Back
Top