csv - how to create column of cell-by-cell sums in excel -
i have spreadsheet extremely long , create new column (actually, 8) each cell in new column sum of 2 cells in other columns. obvious answer create column, create instance of formula in first cell, , drag formula down. however, since spreadsheet long , 8 times, process not make sense me. there automated way this? have never worked vba have enough programming experience figure figure out. thank you.
what do, e.g. long data in columns a
& b
- put formula in
c1
&d1
- click in
b1
, ctrl+down-arrow go last cell, go onc
&d
& type in value - click
c1
, shift+ctrl+down-arrow select empty cells, same left-arrow select horizontally - ctrl+d fill formula
Comments
Post a Comment