+ Reply to Thread
Results 1 to 12 of 12

Changing the auto fill order from ascending to descending

  1. #1
    Dave C.
    Guest

    Changing the auto fill order from ascending to descending

    All,

    I am seeking information on how to change the default auto fill order from
    ascending to descending when using alpha numeric entries.

    To clarify, if you enter data into a cell and then click the lower right
    corner and drag to the next lower cell(s) the value increases. I would like
    it to decrease. How can I set that up.

  2. #2
    Guest

    Re: Changing the auto fill order from ascending to descending

    Hi
    One way is to drag down with the right mouse button and then select Series .
    .. . and select -1 in the Step field.

    --
    Andy.


    "Dave C." <[email protected]> wrote in message
    news:[email protected]...
    > All,
    >
    > I am seeking information on how to change the default auto fill order from
    > ascending to descending when using alpha numeric entries.
    >
    > To clarify, if you enter data into a cell and then click the lower right
    > corner and drag to the next lower cell(s) the value increases. I would
    > like
    > it to decrease. How can I set that up.




  3. #3
    Dave C.
    Guest

    Re: Changing the auto fill order from ascending to descending

    Thanks for the input Andy. I tried that and it did not seem to work. I
    wonder if I need to close the active wb and then reopen it and try again.

    "Andy B" wrote:

    > Hi
    > One way is to drag down with the right mouse button and then select Series .
    > .. . and select -1 in the Step field.
    >
    > --
    > Andy.
    >
    >
    > "Dave C." <[email protected]> wrote in message
    > news:[email protected]...
    > > All,
    > >
    > > I am seeking information on how to change the default auto fill order from
    > > ascending to descending when using alpha numeric entries.
    > >
    > > To clarify, if you enter data into a cell and then click the lower right
    > > corner and drag to the next lower cell(s) the value increases. I would
    > > like
    > > it to decrease. How can I set that up.

    >
    >
    >


  4. #4
    Guest

    Re: Changing the auto fill order from ascending to descending

    When you drag down using the *right* mouse button, a menu should pop up at
    when you release it, with various options on.

    --
    Andy.


    "Dave C." <[email protected]> wrote in message
    news:[email protected]...
    > Thanks for the input Andy. I tried that and it did not seem to work. I
    > wonder if I need to close the active wb and then reopen it and try again.
    >
    > "Andy B" wrote:
    >
    >> Hi
    >> One way is to drag down with the right mouse button and then select
    >> Series .
    >> .. . and select -1 in the Step field.
    >>
    >> --
    >> Andy.
    >>
    >>
    >> "Dave C." <[email protected]> wrote in message
    >> news:[email protected]...
    >> > All,
    >> >
    >> > I am seeking information on how to change the default auto fill order
    >> > from
    >> > ascending to descending when using alpha numeric entries.
    >> >
    >> > To clarify, if you enter data into a cell and then click the lower
    >> > right
    >> > corner and drag to the next lower cell(s) the value increases. I would
    >> > like
    >> > it to decrease. How can I set that up.

    >>
    >>
    >>




  5. #5
    Dave C.
    Guest

    Re: Changing the auto fill order from ascending to descending

    That it does, but when I select the fill option, it just performs the fill,
    but doesn't allow me to select the -1 stepping. However if I go to a blank
    column and type a number then select the entire column and choose
    edit/fill/series/ -1 on the stepping it works.....

    "Andy B" wrote:

    > When you drag down using the *right* mouse button, a menu should pop up at
    > when you release it, with various options on.
    >
    > --
    > Andy.
    >
    >
    > "Dave C." <[email protected]> wrote in message
    > news:[email protected]...
    > > Thanks for the input Andy. I tried that and it did not seem to work. I
    > > wonder if I need to close the active wb and then reopen it and try again.
    > >
    > > "Andy B" wrote:
    > >
    > >> Hi
    > >> One way is to drag down with the right mouse button and then select
    > >> Series .
    > >> .. . and select -1 in the Step field.
    > >>
    > >> --
    > >> Andy.
    > >>
    > >>
    > >> "Dave C." <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > All,
    > >> >
    > >> > I am seeking information on how to change the default auto fill order
    > >> > from
    > >> > ascending to descending when using alpha numeric entries.
    > >> >
    > >> > To clarify, if you enter data into a cell and then click the lower
    > >> > right
    > >> > corner and drag to the next lower cell(s) the value increases. I would
    > >> > like
    > >> > it to decrease. How can I set that up.
    > >>
    > >>
    > >>

    >
    >
    >


  6. #6
    Guest

    Re: Changing the auto fill order from ascending to descending

    Hmmm. Having re-read your post I can see that you are trying this on
    alpha-numerics. It depends on the format they are in - and also the version
    of Excel, I guess.

    --
    Andy.


    "Dave C." <[email protected]> wrote in message
    news:[email protected]...
    > That it does, but when I select the fill option, it just performs the
    > fill,
    > but doesn't allow me to select the -1 stepping. However if I go to a
    > blank
    > column and type a number then select the entire column and choose
    > edit/fill/series/ -1 on the stepping it works.....
    >
    > "Andy B" wrote:
    >
    >> When you drag down using the *right* mouse button, a menu should pop up
    >> at
    >> when you release it, with various options on.
    >>
    >> --
    >> Andy.
    >>
    >>
    >> "Dave C." <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Thanks for the input Andy. I tried that and it did not seem to work.
    >> > I
    >> > wonder if I need to close the active wb and then reopen it and try
    >> > again.
    >> >
    >> > "Andy B" wrote:
    >> >
    >> >> Hi
    >> >> One way is to drag down with the right mouse button and then select
    >> >> Series .
    >> >> .. . and select -1 in the Step field.
    >> >>
    >> >> --
    >> >> Andy.
    >> >>
    >> >>
    >> >> "Dave C." <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > All,
    >> >> >
    >> >> > I am seeking information on how to change the default auto fill
    >> >> > order
    >> >> > from
    >> >> > ascending to descending when using alpha numeric entries.
    >> >> >
    >> >> > To clarify, if you enter data into a cell and then click the lower
    >> >> > right
    >> >> > corner and drag to the next lower cell(s) the value increases. I
    >> >> > would
    >> >> > like
    >> >> > it to decrease. How can I set that up.
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  7. #7
    Dave C.
    Guest

    Re: Changing the auto fill order from ascending to descending

    Kind of puzzling, huh? I am using Excel 2003. This doesn't seem like it
    would be that difficult of a task. It's strange that when you click, either
    left or right mouse button in the lower right corner of the cell and drag
    down, everything goes in ascending order even though it's alpha-numeric.
    Conversely, doing the same in the upper right corner of a cell and dragging
    upward, it has a descending effect. One would think that this process could
    be reversed.

    "Andy B" wrote:

    > Hmmm. Having re-read your post I can see that you are trying this on
    > alpha-numerics. It depends on the format they are in - and also the version
    > of Excel, I guess.
    >
    > --
    > Andy.
    >
    >
    > "Dave C." <[email protected]> wrote in message
    > news:[email protected]...
    > > That it does, but when I select the fill option, it just performs the
    > > fill,
    > > but doesn't allow me to select the -1 stepping. However if I go to a
    > > blank
    > > column and type a number then select the entire column and choose
    > > edit/fill/series/ -1 on the stepping it works.....
    > >
    > > "Andy B" wrote:
    > >
    > >> When you drag down using the *right* mouse button, a menu should pop up
    > >> at
    > >> when you release it, with various options on.
    > >>
    > >> --
    > >> Andy.
    > >>
    > >>
    > >> "Dave C." <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Thanks for the input Andy. I tried that and it did not seem to work.
    > >> > I
    > >> > wonder if I need to close the active wb and then reopen it and try
    > >> > again.
    > >> >
    > >> > "Andy B" wrote:
    > >> >
    > >> >> Hi
    > >> >> One way is to drag down with the right mouse button and then select
    > >> >> Series .
    > >> >> .. . and select -1 in the Step field.
    > >> >>
    > >> >> --
    > >> >> Andy.
    > >> >>
    > >> >>
    > >> >> "Dave C." <[email protected]> wrote in message
    > >> >> news:[email protected]...
    > >> >> > All,
    > >> >> >
    > >> >> > I am seeking information on how to change the default auto fill
    > >> >> > order
    > >> >> > from
    > >> >> > ascending to descending when using alpha numeric entries.
    > >> >> >
    > >> >> > To clarify, if you enter data into a cell and then click the lower
    > >> >> > right
    > >> >> > corner and drag to the next lower cell(s) the value increases. I
    > >> >> > would
    > >> >> > like
    > >> >> > it to decrease. How can I set that up.
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  8. #8
    Guest

    Re: Changing the auto fill order from ascending to descending

    I suppose an alternative is to split up the alpha and numeric bits, fill
    your numeric series with the right mouse button and then concatenate them
    back together. It depends on how big a deal the job is, I guess.

    --
    Andy.


    "Dave C." <[email protected]> wrote in message
    news:[email protected]...
    > Kind of puzzling, huh? I am using Excel 2003. This doesn't seem like it
    > would be that difficult of a task. It's strange that when you click,
    > either
    > left or right mouse button in the lower right corner of the cell and drag
    > down, everything goes in ascending order even though it's alpha-numeric.
    > Conversely, doing the same in the upper right corner of a cell and
    > dragging
    > upward, it has a descending effect. One would think that this process
    > could
    > be reversed.
    >
    > "Andy B" wrote:
    >
    >> Hmmm. Having re-read your post I can see that you are trying this on
    >> alpha-numerics. It depends on the format they are in - and also the
    >> version
    >> of Excel, I guess.
    >>
    >> --
    >> Andy.
    >>
    >>
    >> "Dave C." <[email protected]> wrote in message
    >> news:[email protected]...
    >> > That it does, but when I select the fill option, it just performs the
    >> > fill,
    >> > but doesn't allow me to select the -1 stepping. However if I go to a
    >> > blank
    >> > column and type a number then select the entire column and choose
    >> > edit/fill/series/ -1 on the stepping it works.....
    >> >
    >> > "Andy B" wrote:
    >> >
    >> >> When you drag down using the *right* mouse button, a menu should pop
    >> >> up
    >> >> at
    >> >> when you release it, with various options on.
    >> >>
    >> >> --
    >> >> Andy.
    >> >>
    >> >>
    >> >> "Dave C." <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Thanks for the input Andy. I tried that and it did not seem to
    >> >> > work.
    >> >> > I
    >> >> > wonder if I need to close the active wb and then reopen it and try
    >> >> > again.
    >> >> >
    >> >> > "Andy B" wrote:
    >> >> >
    >> >> >> Hi
    >> >> >> One way is to drag down with the right mouse button and then select
    >> >> >> Series .
    >> >> >> .. . and select -1 in the Step field.
    >> >> >>
    >> >> >> --
    >> >> >> Andy.
    >> >> >>
    >> >> >>
    >> >> >> "Dave C." <[email protected]> wrote in message
    >> >> >> news:[email protected]...
    >> >> >> > All,
    >> >> >> >
    >> >> >> > I am seeking information on how to change the default auto fill
    >> >> >> > order
    >> >> >> > from
    >> >> >> > ascending to descending when using alpha numeric entries.
    >> >> >> >
    >> >> >> > To clarify, if you enter data into a cell and then click the
    >> >> >> > lower
    >> >> >> > right
    >> >> >> > corner and drag to the next lower cell(s) the value increases. I
    >> >> >> > would
    >> >> >> > like
    >> >> >> > it to decrease. How can I set that up.
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  9. #9
    Dave C.
    Guest

    Re: Changing the auto fill order from ascending to descending

    It would make this particular job easier, but at the same time it's not worth
    the extra effort since I cannot be sure I'll run across something like this
    again. Thanks for your help.

    Dave...

    "Andy B" wrote:

    > I suppose an alternative is to split up the alpha and numeric bits, fill
    > your numeric series with the right mouse button and then concatenate them
    > back together. It depends on how big a deal the job is, I guess.
    >
    > --
    > Andy.
    >
    >
    > "Dave C." <[email protected]> wrote in message
    > news:[email protected]...
    > > Kind of puzzling, huh? I am using Excel 2003. This doesn't seem like it
    > > would be that difficult of a task. It's strange that when you click,
    > > either
    > > left or right mouse button in the lower right corner of the cell and drag
    > > down, everything goes in ascending order even though it's alpha-numeric.
    > > Conversely, doing the same in the upper right corner of a cell and
    > > dragging
    > > upward, it has a descending effect. One would think that this process
    > > could
    > > be reversed.
    > >
    > > "Andy B" wrote:
    > >
    > >> Hmmm. Having re-read your post I can see that you are trying this on
    > >> alpha-numerics. It depends on the format they are in - and also the
    > >> version
    > >> of Excel, I guess.
    > >>
    > >> --
    > >> Andy.
    > >>
    > >>
    > >> "Dave C." <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > That it does, but when I select the fill option, it just performs the
    > >> > fill,
    > >> > but doesn't allow me to select the -1 stepping. However if I go to a
    > >> > blank
    > >> > column and type a number then select the entire column and choose
    > >> > edit/fill/series/ -1 on the stepping it works.....
    > >> >
    > >> > "Andy B" wrote:
    > >> >
    > >> >> When you drag down using the *right* mouse button, a menu should pop
    > >> >> up
    > >> >> at
    > >> >> when you release it, with various options on.
    > >> >>
    > >> >> --
    > >> >> Andy.
    > >> >>
    > >> >>
    > >> >> "Dave C." <[email protected]> wrote in message
    > >> >> news:[email protected]...
    > >> >> > Thanks for the input Andy. I tried that and it did not seem to
    > >> >> > work.
    > >> >> > I
    > >> >> > wonder if I need to close the active wb and then reopen it and try
    > >> >> > again.
    > >> >> >
    > >> >> > "Andy B" wrote:
    > >> >> >
    > >> >> >> Hi
    > >> >> >> One way is to drag down with the right mouse button and then select
    > >> >> >> Series .
    > >> >> >> .. . and select -1 in the Step field.
    > >> >> >>
    > >> >> >> --
    > >> >> >> Andy.
    > >> >> >>
    > >> >> >>
    > >> >> >> "Dave C." <[email protected]> wrote in message
    > >> >> >> news:[email protected]...
    > >> >> >> > All,
    > >> >> >> >
    > >> >> >> > I am seeking information on how to change the default auto fill
    > >> >> >> > order
    > >> >> >> > from
    > >> >> >> > ascending to descending when using alpha numeric entries.
    > >> >> >> >
    > >> >> >> > To clarify, if you enter data into a cell and then click the
    > >> >> >> > lower
    > >> >> >> > right
    > >> >> >> > corner and drag to the next lower cell(s) the value increases. I
    > >> >> >> > would
    > >> >> >> > like
    > >> >> >> > it to decrease. How can I set that up.
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  10. #10
    Gord Dibben
    Guest

    Re: Changing the auto fill order from ascending to descending

    Dave

    Either..........

    1. Enter a100 in A1 and a99 in A2 then drag down or

    2. Enter a100 in A1 and =A1-1 in A2 and drag down.

    AFAIK you cannot change the ascending order of Autofill when only 1 cell has a
    value.


    Gord Dibben Excel MVP

    On Tue, 26 Apr 2005 07:42:03 -0700, "Dave C."
    <[email protected]> wrote:

    >All,
    >
    >I am seeking information on how to change the default auto fill order from
    >ascending to descending when using alpha numeric entries.
    >
    >To clarify, if you enter data into a cell and then click the lower right
    >corner and drag to the next lower cell(s) the value increases. I would like
    >it to decrease. How can I set that up.



  11. #11
    Registered User
    Join Date
    08-29-2008
    Location
    Canada
    Posts
    6

    Re: Changing the auto fill order from ascending to descending

    I believe all you have to do is Set the Patter

    Type in the order you want in 2 or 3 cells
    hHglight those cells
    Click on the black square on the bottom and drag the box [and cells] the direction and the number of cells you need.

    For example I wanted 1 - 12 in reverse order
    In B14 I typed 1
    In B13 I typed 2
    In B12 I typed 3 - just to make sure not necessary

    Selected B12 - B14

    Left Click and drag black square up to B3.

    I now have the following in the cells indicated.

    B3 12
    B4 11
    B5 10
    B6 9
    B7 8
    B8 7
    B9 6
    B10 5
    B11 4
    B12 3
    B13 2
    B14 1

    This seems easier than the other solutions but will this help.

    Lianne

  12. #12
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Changing the auto fill order from ascending to descending

    6-year old thread....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1