Tabing to different cells

[rstone25]

Hi,

Is it possible to tab to certain cells in excel.
The reason for this is I have a layout which has Name(A5), Address(C5), Age(E5). I want to be able to press a key (Tab, F11, etc) and it move directly to the cell on the immediate right so I can fill in the answer. I have thought about a macro, but wondered if there is any other way.

Thanks

 

[Paul B]

If you protect the sheet tab will move between unlocked cells, that would be one way. Paul

On 2002-02-18 03:03, rstone25 wrote:
Hi,

Is it possible to tab to certain cells in excel.
The reason for this is I have a layout which has Name(A5), Address(C5), Age(E5). I want to be able to press a key (Tab, F11, etc) and it move directly to the cell on the immediate right so I can fill in the answer. I have thought about a macro, but wondered if there is any other way.

Thanks

 

[rstone25]

Thanks, that has fixed it.

On 2002-02-18 04:08, Paul B wrote:
If you protect the sheet tab will move between unlocked cells, that would be one way. Paul

On 2002-02-18 03:03, rstone25 wrote:
Hi,

Is it possible to tab to certain cells in excel.
The reason for this is I have a layout which has Name(A5), Address(C5), Age(E5). I want to be able to press a key (Tab, F11, etc) and it move directly to the cell on the immediate right so I can fill in the answer. I have thought about a macro, but wondered if there is any other way.

Thanks