+ Reply to Thread
Results 1 to 2 of 2

Drag horizontally but have formula increase vertically?

  1. #1
    Registered User
    Join Date
    07-04-2011
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2003
    Posts
    7

    Post Drag horizontally but have formula increase vertically?

    I wasn't quite sure how to word this question for a google search, so hopefully someone here can help me.

    Is there a way to drag sideways to fill cells with a formula, but instead of the cell reference increasing sideways, it increases vertically?

    For example, if I have =B1+A1 in a cell, can I drag it across to fill the adjacent cell, but have the formula increase to =C1+A2, instead of C1+B1??

  2. #2
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Drag horizontally but have formula increase vertically?

    For example, if I have =B1+A1 in a cell, can I drag it across to fill the adjacent cell, but have the formula increase to =C1+A2, instead of C1+B1??
    no, it is impossible,
    except for using INDIRECT function, like that
    =C$1+INDIRECT("A"&(COLUMNS($A:B)))

+ 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