+ Reply to Thread
Results 1 to 4 of 4

Formula Autofill

  1. #1
    Registered User
    Join Date
    03-02-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    29

    Formula Autofill

    Hi there,

    I have in cell D4 have =C4*Who!AR1
    I have in cell D4 have =C5*Who!AS1
    I have in cell D4 have =C6*Who!AT1


    I need to fill down the above formula but not sure how.

    help would be appreciated.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    07-19-2012
    Location
    Redmond, WA
    MS-Off Ver
    Excel Professional Plus 2010 and 2007
    Posts
    130

    Re: Formula Autofill

    Highlight all 3. There should be a little square on the bottom right. Click and hold that, then drag down as far as you can (or want to... that is...).

  3. #3
    Registered User
    Join Date
    03-02-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Formula Autofill

    Thanks for that but that will increment the rows not columns.

    your suggestions will do the following

    Cell D4 =C4*Who!AR1
    Cell D5 =C5*Who!AR2
    Cell D6 =C6*Who!AR3

    I want it to do

    Cell D4 =C4*Who!AR1
    Cell D5 =C5*Who!AS1
    Cell D6 =C6*Who!AT1 and so on.

    So it will fill down in C column but fill right in Who sheet AR, AS, AT, AU, AV and on.

    I hope this makes sense?

  4. #4
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Formula Autofill

    Have a look at this
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

+ 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