| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom lists - not following defined order
I have made the following custom list.
GR2-E7 GR4-E7 REST G-E7 GR2-E7 G-E7 G-E7 REST G-E7 GR2-E7 GR4-E7 REST G-E7 When using the fill method by dragging from the first cell (i.e. GR2-E7) excel reaches the second GR2-E7 it should goto G-E7, G-E7, etc. However, it then follows with GR4-E7. Note: I am dragging from left to right. Any ideas as I have loads of rows to fill, and I dont want the users to do this manually. Thanks in advance. |
|
#2
|
|||
|
|||
|
During an autofill, XL will start filling with the *last* matching entry
in the list (e.g., the third GR2-E7), then loops back to the top. Reorder your list accordingly. In article .com, wrote: I have made the following custom list. GR2-E7 GR4-E7 REST G-E7 GR2-E7 G-E7 G-E7 REST G-E7 GR2-E7 GR4-E7 REST G-E7 When using the fill method by dragging from the first cell (i.e. GR2-E7) excel reaches the second GR2-E7 it should goto G-E7, G-E7, etc. However, it then follows with GR4-E7. Note: I am dragging from left to right. Any ideas as I have loads of rows to fill, and I dont want the users to do this manually. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining a default worksheet order | Excel Discussion (Misc queries) | |||
| Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
| Custom Views Not Accessible | Excel Discussion (Misc queries) | |||
| Data association | Excel Worksheet Functions | |||
| HOW DO I USE A CUSTOM LISTS | New Users to Excel | |||
Linear Mode
