| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tab order for multi-range selections
Is there any way to control this? For example, if I "Edit Go To
Special Data validation Same" and then tab thru the selected cells, I might start at C5 and go from there to C6, C7, G5, G6, G7, C20, E5, E6, E7, E20, I20, A5, A6, A7, I5, I6, I7, A20, and then back to C5. This means that somewhere this selection is represented internally as "C5:7,G5:7,C20,E5:7,E20,I20,A5:7,I5:7,A20"; is there any way I can change that to something more logical, like "A5:7,C5:7,E5:7,G5:7,I5:7,A20,C20,E20,I20"? |
|
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
|
tab order for multi-range selections
Sorry - I posted this to the wrong group (I think)
Is there any way to control this? For example, if I "Edit Go To Special Data validation Same" and then tab thru the selected cells, I might start at C5 and go from there to C6, C7, G5, G6, G7, C20, E5, E6, E7, E20, I20, A5, A6, A7, I5, I6, I7, A20, and then back to C5. This means that somewhere this selection is represented internally as "C5:7,G5:7,C20,E5:7,E20,I20,A5:7,I5:7,A20"; is there any way I can change that to something more logical, like "A5:7,C5:7,E5:7,G5:7,I5:7,A20,C20,E20,I20"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tab order for multi-range selections | Excel Discussion (Misc queries) | |||
| How do i order selections contigously | Excel Worksheet Functions | |||
| multi range identify & replace | Excel Worksheet Functions | |||
| Multi-Column Dynamic Named Range...Is there an easier way? | Excel Worksheet Functions | |||
| How do I keep multi-subtotals in the same order within the report | Excel Worksheet Functions | |||
Linear Mode
