| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a custom fill series or sorting order
I have created and added my "custom list" to my worksheet, How do I make
excel autofill from that list? I have typed these items in my worksheet and as long as the cell I am typing in is directly adjacent to the list IT WILL autofill. If I put space in between the list and the cell I want to autofill then it will not fill. I'M CONFUSED |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a custom fill series or sorting order
You have "autofil" and "autocomplete" confused.
Autofill uses a custom list to fill when you enter an item then drag/copy down or across. The months of the year are an example of an autofill list. Autocomplete on the other hand does not use a list.......it uses the cells above or below where you are typing and needs to be contiguous. Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 08:23:01 -0800, jerminski73 wrote: I have created and added my "custom list" to my worksheet, How do I make excel autofill from that list? I have typed these items in my worksheet and as long as the cell I am typing in is directly adjacent to the list IT WILL autofill. If I put space in between the list and the cell I want to autofill then it will not fill. I'M CONFUSED |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill series, custom format question | Excel Discussion (Misc queries) | |||
| How do I create a custom fill series for dates? | Excel Discussion (Misc queries) | |||
| Custom fill series? | Excel Discussion (Misc queries) | |||
| Can I create a random order within a series of numbers in Excel? | Excel Worksheet Functions | |||
| I've created a custom fill series. Now I don't know how to use i. | Excel Discussion (Misc queries) | |||
Hybrid Mode
