Set Row in Function Automatically in Microsoft Excel

[Jason Betts]

Hi guys, I am making a spreadsheet and I want to add the values of two cells within the same row (say, D2 and E2). I know how to do this, it's =D2+E2, but if I copy and paste this to a bunch of lower rows I'd then have to change each to =D3+E3 and =D4+E4, etc. 

 

How do I tell Excel I want it to add the cell in column D row whatever row we're on to column E row whatever row we're on? 

 

Thanks, Jason.

[LogicalDrm]

So you want to have column F which each rom has values "=D(x)+E(x)"? This is simply done by cloning cells. You enter formula in first cell and then pull from handle at bottom right corner. Pull it over all the cells you want to have that formula. Don't worry about adding more rows later, you can continue cloning cells later. If you would like one value remaining but other changing according to each row, add $ between letter and row number to tell Excel you want that cell to remain static over cloning process. Like "=D$4+E4". Cloning that to next cell on next row would be "=D$4+E5".

[Jason Betts]

On 9/8/2016 at 1:05 AM, LoGiCalDrm said:

So you want to have column F which each rom has values "=D(x)+E(x)"? This is simply done by cloning cells. You enter formula in first cell and then pull from handle at bottom right corner. Pull it over all the cells you want to have that formula. Don't worry about adding more rows later, you can continue cloning cells later. If you would like one value remaining but other changing according to each row, add $ between letter and row number to tell Excel you want that cell to remain static over cloning process. Like "=D$4+E4". Cloning that to next cell on next row would be "=D$4+E5".

Thanks, that's perfect!