LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 205
Default Excel - How to get tab to go to next unlocked cell across columns

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
tab to next unlocked cell ajimmitt Excel Discussion (Misc queries) 1 March 19th 10 01:39 AM
Bypass unlocked cell on protected worksheet in Excel 2003? berniean Excel Discussion (Misc queries) 8 July 28th 09 11:10 PM
Inserting comment in unlocked cell of protected Excel worksheet? Mike Ives Excel Worksheet Functions 1 January 30th 09 12:06 AM
Moving from unlocked cells to unlocked cells in an excel form Stacey Lee Excel Worksheet Functions 1 April 24th 06 08:44 PM
How do i enter a note in excel to an unlocked cell on a protected. Kev Excel Discussion (Misc queries) 1 January 17th 05 11:17 PM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"