Auotmatic Tabs

cstach

New Member
Joined
Nov 23, 2005
Messages
1
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. :biggrin:
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,058
Messages
5,569,957
Members
412,300
Latest member
Chaneycr
Top