+ Reply to Thread
Results 1 to 3 of 3

Dragging Down Formulas with Constant Cells

  1. #1
    Forum Contributor
    Join Date
    06-08-2008
    Location
    USA
    MS-Off Ver
    Mac Excel 2016
    Posts
    103

    Dragging Down Formulas with Constant Cells

    Is there any way to use the cross in the bottom right corner of each cell to drag a formula with some cells that vary, but others that remain constant?

    For example:
    If I want the formula to be:
    B2+C2
    B3+C2
    B4+C2
    B5+C2, etc.

    Is there a way to drag "B2+C2" down to make it look like the list above, rather than dragging it down to see:
    B2+C2
    B3+C3
    B4+C4
    B5+C5, etc.

    Thank you!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613
    Try:
    B2+$C$2
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    06-08-2008
    Location
    USA
    MS-Off Ver
    Mac Excel 2016
    Posts
    103
    That's exactly what I was looking for!

    Thank you!

+ 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