Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Problem
I am trying to use the Auto Fill feature, selecting a range of values and
dragging the + to fill in the range. My problem is that when I select A, B, C, D, and drag the box down, instead of getting A, B, C, D, E, F, G, H, etc., I get A, B, C, D, A, B, C, D, A, B, C, D, How do I get it to continue the series, rather than duplication the above? The cells are formatted "general". (Windows XP SP2, Excel 2003) Thank you, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Problem
You need to create a custom list first
put the alphabet in let's say A1:A26 by typing them manually or by putting this in A1 and copy down =CHAR(ROW(65:65)) then select A1:A26, copy the values and do editpaste special and select values the do toolsoptionscustom lists, click import and add. From now on you will get what you expected. Of course you could always use the formula solution as well -- Regards, Peo Sjoblom "John Gregory" wrote in message ... I am trying to use the Auto Fill feature, selecting a range of values and dragging the + to fill in the range. My problem is that when I select A, B, C, D, and drag the box down, instead of getting A, B, C, D, E, F, G, H, etc., I get A, B, C, D, A, B, C, D, A, B, C, D, How do I get it to continue the series, rather than duplication the above? The cells are formatted "general". (Windows XP SP2, Excel 2003) Thank you, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Problem
Thank you very much, that worked!
I would have expected that an alphabetical list would have been included as a standard item. "Peo Sjoblom" wrote: You need to create a custom list first put the alphabet in let's say A1:A26 by typing them manually or by putting this in A1 and copy down =CHAR(ROW(65:65)) then select A1:A26, copy the values and do editpaste special and select values the do toolsoptionscustom lists, click import and add. From now on you will get what you expected. Of course you could always use the formula solution as well -- Regards, Peo Sjoblom "John Gregory" wrote in message ... I am trying to use the Auto Fill feature, selecting a range of values and dragging the + to fill in the range. My problem is that when I select A, B, C, D, and drag the box down, instead of getting A, B, C, D, E, F, G, H, etc., I get A, B, C, D, A, B, C, D, A, B, C, D, How do I get it to continue the series, rather than duplication the above? The cells are formatted "general". (Windows XP SP2, Excel 2003) Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Auto Fill | Excel Discussion (Misc queries) | |||
Auto Fill | Excel Discussion (Misc queries) | |||
Auto fill in | Excel Discussion (Misc queries) | |||
using auto fill edit or fill handel | Excel Worksheet Functions |