| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell content - data entry order by enduser
I locked and validated cells in a .xls worksheet for endusers to complete
[credit card application] As i tab through the form to add data....the cells selected don't go in a chronological order. Can someone assist in how I fix this issue within Excel. much appreciated Tammy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell content - data entry order by enduser
The tabbing in a protected sheet follows standard XL rules. Left to right,
then top to bottom. Perhaps you need to rearrange the layout of your form? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tammy" wrote: I locked and validated cells in a .xls worksheet for endusers to complete [credit card application] As i tab through the form to add data....the cells selected don't go in a chronological order. Can someone assist in how I fix this issue within Excel. much appreciated Tammy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell content - data entry order by enduser
You could use a named range which you would design in the order you want to
move. See Bob Phillips' site for more. http://www.xldynamic.com/source/xld.xlFAQ0008.html Gord Dibben MS Excel MVP On Wed, 8 Apr 2009 12:01:07 -0700, Tammy wrote: I locked and validated cells in a .xls worksheet for endusers to complete [credit card application] As i tab through the form to add data....the cells selected don't go in a chronological order. Can someone assist in how I fix this issue within Excel. much appreciated Tammy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Original Sort/Data Entry Order | Excel Discussion (Misc queries) | |||
| Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
| how do you flip the order of the content in a cell. | Excel Worksheet Functions | |||
| trace order of data entry | New Users to Excel | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Linear Mode
