Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation -- using arrow keys
In editing a list in Data Validation and using the arrow keys it will not
help me move around in the list, but will select the cells around the fields I'm validation, and thus will enter into the list things along the lines of: =$E$1 Is there a way I can switch the focus to the list so that I can use the arrow keys to move within the list? |
#2
|
|||
|
|||
Click on the cell and hit Alt+Down arrow key until your selection is made.
************ Anne Troy www.OfficeArticles.com "MatthewTap" wrote in message ... In editing a list in Data Validation and using the arrow keys it will not help me move around in the list, but will select the cells around the fields I'm validation, and thus will enter into the list things along the lines of: =$E$1 Is there a way I can switch the focus to the list so that I can use the arrow keys to move within the list? |
#3
|
|||
|
|||
Thanks.
I see that's a way I can make a selection, but I guess the problem I'm having more of an issue with is when I go to make a change to the list... going to Data Validation click on List and then try and edit the list... I can use my mouse to get around, and I'm not really at a stopping point, but if I click in the list and want to use the arrow keys [number pad or keyboard], it doesn't allow me to move in the list [which at the time is a text field]. Let me know if that makes more sense. "Anne Troy" wrote: Click on the cell and hit Alt+Down arrow key until your selection is made. ************ Anne Troy www.OfficeArticles.com "MatthewTap" wrote in message ... In editing a list in Data Validation and using the arrow keys it will not help me move around in the list, but will select the cells around the fields I'm validation, and thus will enter into the list things along the lines of: =$E$1 Is there a way I can switch the focus to the list so that I can use the arrow keys to move within the list? |
#4
|
|||
|
|||
In the data validation dialog box, if you press the F2 key, you can use
the arrow keys to move in the source definition box. MatthewTap wrote: Thanks. I see that's a way I can make a selection, but I guess the problem I'm having more of an issue with is when I go to make a change to the list... going to Data Validation click on List and then try and edit the list... I can use my mouse to get around, and I'm not really at a stopping point, but if I click in the list and want to use the arrow keys [number pad or keyboard], it doesn't allow me to move in the list [which at the time is a text field]. Let me know if that makes more sense. "Anne Troy" wrote: Click on the cell and hit Alt+Down arrow key until your selection is made. ************ Anne Troy www.OfficeArticles.com "MatthewTap" wrote in message ... In editing a list in Data Validation and using the arrow keys it will not help me move around in the list, but will select the cells around the fields I'm validation, and thus will enter into the list things along the lines of: =$E$1 Is there a way I can switch the focus to the list so that I can use the arrow keys to move within the list? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Thank you... odd I didn't try F2, but it's nice to know now.
thanks to both of you for your time. "Debra Dalgleish" wrote: In the data validation dialog box, if you press the F2 key, you can use the arrow keys to move in the source definition box. MatthewTap wrote: Thanks. I see that's a way I can make a selection, but I guess the problem I'm having more of an issue with is when I go to make a change to the list... going to Data Validation click on List and then try and edit the list... I can use my mouse to get around, and I'm not really at a stopping point, but if I click in the list and want to use the arrow keys [number pad or keyboard], it doesn't allow me to move in the list [which at the time is a text field]. Let me know if that makes more sense. "Anne Troy" wrote: Click on the cell and hit Alt+Down arrow key until your selection is made. ************ Anne Troy www.OfficeArticles.com "MatthewTap" wrote in message ... In editing a list in Data Validation and using the arrow keys it will not help me move around in the list, but will select the cells around the fields I'm validation, and thus will enter into the list things along the lines of: =$E$1 Is there a way I can switch the focus to the list so that I can use the arrow keys to move within the list? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
Another tip for moving through dialog boxes.
When editing the "refers to" address in the Define Name dialog, hit the F2 key and then you can move forth and back using the arrow keys. On the status bar you will see "point" or "edit". When in "point" mode you cannot scroll through the dialog box. Gord Dibben Excel MVP On Fri, 14 Oct 2005 08:40:16 -0700, "MatthewTap" wrote: Thank you... odd I didn't try F2, but it's nice to know now. thanks to both of you for your time. "Debra Dalgleish" wrote: In the data validation dialog box, if you press the F2 key, you can use the arrow keys to move in the source definition box. MatthewTap wrote: Thanks. I see that's a way I can make a selection, but I guess the problem I'm having more of an issue with is when I go to make a change to the list... going to Data Validation click on List and then try and edit the list... I can use my mouse to get around, and I'm not really at a stopping point, but if I click in the list and want to use the arrow keys [number pad or keyboard], it doesn't allow me to move in the list [which at the time is a text field]. Let me know if that makes more sense. "Anne Troy" wrote: Click on the cell and hit Alt+Down arrow key until your selection is made. ************ Anne Troy www.OfficeArticles.com "MatthewTap" wrote in message ... In editing a list in Data Validation and using the arrow keys it will not help me move around in the list, but will select the cells around the fields I'm validation, and thus will enter into the list things along the lines of: =$E$1 Is there a way I can switch the focus to the list so that I can use the arrow keys to move within the list? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
DATA VALIDATION with LEFT function | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |