want to automatically skip certain cells when you hit enter

[IanC]

I don't think you can do this. However, you CAN arrange to skip cells when
you hit TAB.

Select the cells you want accessible, then go to Format > Cells >
Protection, uncheck Locked and click OK (or hit enter).
Go to Tools > Protection > Protect Sheet, enter a password if required, then
click OK.

Hitting Tab will skip to the next unlocked cell (working along rows, then
down). Also the only cells where data can be edited are the unlocked ones.

 

[Gord Dibben]

See Bob Phillips' site for a couple of methods to set the Tab order.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is also a VBA method using sheet event code if you want it.

Post back if so.


Gord Dibben MS Excel MVP