formatting spreadsheet cells to tab between

[Jennifer]

I have a spreadsheet that I want to set up where I can tab between the cells
I use and not have to click through. Hoping to set it up to tab the the next
cell that has information, and not keep going past that. Anyone?

 

[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