View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?