In Excel 2000, can I change the direction of the move selection a.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2000, can I change the direction of the move selection after Tab? (I
know you can change the dirrection after Enter)
 
GTP

Not possible I'm afraid

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
If you have a specific pattern to follow...

Snipped from a Gord Dibben post:

One method is......make a named range for your cells then select this name
from the namebox.

Assume you want to go from D10 to A1 to B4 to C8

Hold CRTL key down as you select cells. Start with second cell(A1 in this
case) then select B4, C8 and last D10.

With cells still selected, go to Insert>Name>Define. Type in a name and OK.

De-select cells by clicking on any other cell. Now click on namebox(just
above row1 and left of column A. Pick your name from the list. Your range
will be highlighted with D10 as active cell. Enter your data then hit ENTER
key to move through the range.

=====
And it works with tabs, too (well, if the sheet isn't protected)
 
You must log in or register to reply here.

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

change direction when pressing enter 7
change direction when hitting enter key 1
change direction active cell indicator moves when enter key is pre 2
"Move selection after Enter" 3
Entering 'GTi' but I get 'Gti' ! 2
Move selection 3
importing numbers as text 5
Maintaining hyperlinks when I move Excel files to another location 1

Back
Top