TAB down then right instead of right then down?

  • Thread starter Thread starter TR Young
  • Start date Start date
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?
 
Hi

in excel 2007 go to the microsoft button, excel options, advance, editing
options,after pressing enter move selection, change it to down
 
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.
 
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
 
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
Click to expand...
 
Back
Top