Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two column
I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two column
Tools | Options | [Edit] tab - check out the option labeled "Move Selection
After Enter ... Direction" - it has options, one of which is Down! "Teresa" wrote: I have created an Excel Form that has two different columns of "blanks" and I am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two col
Thanks JL. I already tried that and it does in fact go to the line below. The
problem is that There is a space(s) between each 'answer' field and I would like to jump a line or so to go directly to the next field for data entry. Any suggestions for that? "JLatham" wrote: Tools | Options | [Edit] tab - check out the option labeled "Move Selection After Enter ... Direction" - it has options, one of which is Down! "Teresa" wrote: I have created an Excel Form that has two different columns of "blanks" and I am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two column
Can you live with sheet protection?
Select the range for users to enter data.......say A1:B20 FormatCellsProtectionUncheck "locked" options. ToolsProtectionProtect SheetUncheck "select locked cells" and OK With ENTER key set to move down start entering in A1. Alternative is to use a named range. Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then A1 last InsertNameDefine. Give your range a name like MyRange In Nmaebox select MyRange and start typing and ENTERing Gord Dibben MS Excel MVP On Mon, 5 Mar 2007 09:32:11 -0800, Teresa wrote: I have created an Excel Form that has two different columns of "blanks" and I am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two col
I do have the sheet protection on. I will try the rest of it and let you
know. Thanks "Gord Dibben" wrote: Can you live with sheet protection? Select the range for users to enter data.......say A1:B20 FormatCellsProtectionUncheck "locked" options. ToolsProtectionProtect SheetUncheck "select locked cells" and OK With ENTER key set to move down start entering in A1. Alternative is to use a named range. Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then A1 last InsertNameDefine. Give your range a name like MyRange In Nmaebox select MyRange and start typing and ENTERing Gord Dibben MS Excel MVP On Mon, 5 Mar 2007 09:32:11 -0800, Teresa wrote: I have created an Excel Form that has two different columns of "blanks" and I am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two col
It should work if set up the way Gord Dibben has instructed. That's about
the only way I know to skip cells without resorting to VB code (or clicking with a mouse or entering directly into the Name Box - I mention those to keep others from reminding me that those options exist). "Teresa" wrote: I do have the sheet protection on. I will try the rest of it and let you know. Thanks "Gord Dibben" wrote: Can you live with sheet protection? Select the range for users to enter data.......say A1:B20 FormatCellsProtectionUncheck "locked" options. ToolsProtectionProtect SheetUncheck "select locked cells" and OK With ENTER key set to move down start entering in A1. Alternative is to use a named range. Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then A1 last InsertNameDefine. Give your range a name like MyRange In Nmaebox select MyRange and start typing and ENTERing Gord Dibben MS Excel MVP On Mon, 5 Mar 2007 09:32:11 -0800, Teresa wrote: I have created an Excel Form that has two different columns of "blanks" and I am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two col
Ok guys. I did work...BUT, now it has decided to skip over one of the cells.
It is a 'drop list' created through the validation. I have others in the form and they are woking fine. It just skips right over it. I can tab to it, but not enter. Help? Any further suggestions? (other than 'give it up') "JLatham" wrote: It should work if set up the way Gord Dibben has instructed. That's about the only way I know to skip cells without resorting to VB code (or clicking with a mouse or entering directly into the Name Box - I mention those to keep others from reminding me that those options exist). "Teresa" wrote: I do have the sheet protection on. I will try the rest of it and let you know. Thanks "Gord Dibben" wrote: Can you live with sheet protection? Select the range for users to enter data.......say A1:B20 FormatCellsProtectionUncheck "locked" options. ToolsProtectionProtect SheetUncheck "select locked cells" and OK With ENTER key set to move down start entering in A1. Alternative is to use a named range. Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then A1 last InsertNameDefine. Give your range a name like MyRange In Nmaebox select MyRange and start typing and ENTERing Gord Dibben MS Excel MVP On Mon, 5 Mar 2007 09:32:11 -0800, Teresa wrote: I have created an Excel Form that has two different columns of "blanks" and I am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up top to bottom movement for a Form with two col
A contradiction here in my mind.............
"skips right over it" and "I can Tab to it but not enter". Which is it? What happens when you try to enter? A DV drop-down list should throw an error if you try to enter something not on the list. Gord On Tue, 6 Mar 2007 06:26:40 -0800, Teresa wrote: Ok guys. I did work...BUT, now it has decided to skip over one of the cells. It is a 'drop list' created through the validation. I have others in the form and they are woking fine. It just skips right over it. I can tab to it, but not enter. Help? Any further suggestions? (other than 'give it up') "JLatham" wrote: It should work if set up the way Gord Dibben has instructed. That's about the only way I know to skip cells without resorting to VB code (or clicking with a mouse or entering directly into the Name Box - I mention those to keep others from reminding me that those options exist). "Teresa" wrote: I do have the sheet protection on. I will try the rest of it and let you know. Thanks "Gord Dibben" wrote: Can you live with sheet protection? Select the range for users to enter data.......say A1:B20 FormatCellsProtectionUncheck "locked" options. ToolsProtectionProtect SheetUncheck "select locked cells" and OK With ENTER key set to move down start entering in A1. Alternative is to use a named range. Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then A1 last InsertNameDefine. Give your range a name like MyRange In Nmaebox select MyRange and start typing and ENTERing Gord Dibben MS Excel MVP On Mon, 5 Mar 2007 09:32:11 -0800, Teresa wrote: I have created an Excel Form that has two different columns of "blanks" and I am trying to set it up for the user to go down one column and then down the second column. I would prefer the cursor to not go 'left - to right'. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Move from bottom of one column to top of next | Excel Discussion (Misc queries) | |||
dislike jump bottom of column by double-clicking the bottom of cel | Excel Discussion (Misc queries) | |||
change form from top to bottom to side to side | Excel Discussion (Misc queries) | |||
Scrollbars starting at the bottom of form | Excel Discussion (Misc queries) | |||
How do I restrict data movement (cut & paste) to only one column? | Excel Discussion (Misc queries) |