formatting spreadsheet cells to tab between
 

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?

formatting spreadsheet cells to tab between
 

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

On Fri, 11 Jul 2008 08:44:01 -0700, Jennifer
wrote:

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?