+ Reply to Thread
Results 1 to 5 of 5

Simple manual autofill not working

  1. #1
    Registered User
    Join Date
    07-30-2012
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    6

    Simple manual autofill not working

    I have an alphanumeric field which I would like to autofill - but it only copies. Can it be done?

    For example:
    Value: Q2.1
    I want to autofill Q2.1.a, Q2.1.b, Q2.1.c, ...

    I've tried clicking and dragging with Q2.1.a and Q2.1.b highlighted but it just repeats the value (Q2.1.a, Q2.1.b, Q2.1.a, Q2.1.b,..)
    When I autofill Q2.1 it increments correctly: Q2.1, Q2.2, Q2.3, ...

    How can I autofill the tertiary outline level?

    Any help would be appreciated!
    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Simple manual autofill not working

    You could put this formula in your first cell:

    ="Q2.1."&CHAR(ROWS($1:1)+96)

    and then copy it down as required.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-30-2012
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Simple manual autofill not working

    Thank you Pete. I will use that formula.

    I have multiple "Q" values so was hoping the autofill would be able to handle it.

    I replaced the alpha with a number and it autofilled correctly - then I tried just a, b and it was copying again... I thought autofill also worked on alpha values...

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Simple manual autofill not working

    also you could try this one

    in A1
    ="Q2.1."&LOWER(SUBSTITUTE(ADDRESS(1,ROW(),4),"1",""))

    this will change if on other row here:
    ="Q2.1."&LOWER(SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1",""))
    fill down

    Q2.1.a
    Q2.1.b
    Q2.1.c
    ......
    .....

    hth.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Simple manual autofill not working

    Thanks for the rep. FPS

    if you have time can you mark this thread "SOLVED".

    Look below my signature for the steps.

    thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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