Auotmatic Tabs

[cstach]

Hi, can anyone tell me if Excel allows automatic tab setting? Example I am in cell A1 and when I hit tab I want it to automaticially move to cell d3. I do not know if this is a macro or a formattting issue or whether Excel even does this. I would greatly appreceiate any directions (or webistes for instruction) you can give me. Thank you.

 

[Oaktree]

Welcome to the board.

One way would be to unlock cells A1 and D3 (format --> cells --> protection --> uncheck locked).

Then, protect the sheet (tools --> protection --> protect sheet) and do not allow users to select locked cells. Pressing Tab will alternate between A1 and D3

 

[Greg Truby]

A similar question. But jump was within same row. I'd try Oaktree's advice first (same as Zack's in the other thread). http://www.mrexcel.com/board2/viewtopic.php?t=79685