Results 1 to 3 of 3

Drag autosum formula down but refrences cells horizontally

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    MS EXCEL 2010
    Posts
    210

    Drag autosum formula down but refrences cells horizontally

    Is it possible to put in cell A1 a formula like "=B1" and then drag that formula down to A2 and have the formula change to "=C1" and if I continue to drag down in column A it would continue to shift the formula horizontally to "=D1","=E1", etc. I find myself having to do this sort of thing a lot where in cell A1 I click auto sum and then reference the cell I want it to sum but instead of dragging the formula down I have to then hit auto sum again and then click the cell to the right of the previous cell I want to reference.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Drag horizontally and copy vertical cells
    By shamskh2 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-11-2020, 12:33 PM
  2. formula to drag horizontally to equal vertical cells
    By jasonanthony in forum Excel General
    Replies: 6
    Last Post: 05-14-2015, 03:24 AM
  3. Replies: 5
    Last Post: 11-28-2012, 10:51 AM
  4. Replies: 4
    Last Post: 09-26-2012, 12:42 PM
  5. Drag horizontally but have formula increase vertically?
    By Greg_2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2011, 09:24 AM

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