TAB down then right instead of right then down?


T

TR Young

Is it possible to set up Excel to change the function of the TAB key to tab
DOWN a column then RIGHT to the next column instead of RIGHT across a row
then DOWN to the next row?
 
Ad

Advertisements

E

Eduardo

Hi

in excel 2007 go to the microsoft button, excel options, advance, editing
options,after pressing enter move selection, change it to down
 
T

TR Young

Thanks, Eduardo.

Two problems, however...

First, I neglected to mention that I am using Excel 2003.

Second, I need this to work with the TAB key because I have all cells locked
except for cells that need data entered into them. The TAB key will TAB
from Left to Right and land on any cells that are unlocked for editing. The
ENTER key will drop downward onto cells that are locked, instead of only
going to unlocked cells. I need to TAB downward until the last unlocked
cell is reached, then TAB to the right to the top of the next column where
information is to be entered.
 
G

Gord Dibben

When protecting the sheet disable allow users to "select locked cells"

Then your Enter key will skip the locked cells going down.

When it reaches the bottom locked cell in that column it will jump to top of
next column.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

T

TR Young

Thank you, Gord. That is exactly what I needed.

Gord Dibben said:
When protecting the sheet disable allow users to "select locked cells"

Then your Enter key will skip the locked cells going down.

When it reaches the bottom locked cell in that column it will jump to top
of
next column.


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

Top