View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

I'm not sure whether this will work for you,
but it's a harmless play
(hang around for better suggestions ..)

Let's say we want to tab from A1 to F1,
then hard return to A2, tab to F2, and so on

In a new sheet,
Hold CTRL down, select cols A and F
Click Format Cells Protection tab Uncheck "Locked" OK
Click Tools Protection Protect Sheet OK

Try it out:
Select A1, press Tab, ENTER, Tab, ENTER ...
You'll get the zig-zag jumps: A1-F1-A2-F2-A3-F3 ...
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Naveed Ahmad Purewal" <Naveed Ahmad
wrote in message ...
i want to know how to change the setting of cursor with tab key from one
column to the other, can it be set to move directly to the 5th or what

ever
the number of column we wish to with one hit on tab key?