View Single Post
  #4  
Old April 22nd, 2010, 09:12 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel - How to get tab to go to next unlocked cell across columns

Depends on how the cells are merged.

See my reply to Jerry.


Gord Dibben MS Excel MVP

On Thu, 22 Apr 2010 08:14:01 -0700, Linda
wrote:

Is there any way to use Excel as a form for data entry and have the enter
and/or tab key take you to the next cell for data entry when the next cell.
Specifically, I have a form setup and it has merged fields at different
places. I need the ability to enter across a line and at the end of that
line for the next enter or tab to take me back to column A on the next
unlocked cell. Is this possible?