Saturday, October 17, 2009

Google Docs - spreadsheet - set formula for a whole column/row


If you want the column C to be the sum of column A and B, i.e.
   C1 = A1 + B1
   C2 = A2 + B2
   C3 = A3 + B3
   ...
you don't have to click on each cell of column C and add the formula repeatedly. Instead, you can:

1. Set formula for cell C1. And press the Enter button.


2. Select cell C1. You can see a little blue square at the bottom-right corner.


3. Move the mouse over the little blue square until it becomes a cross. Click down and hold the left button (or right button if you are left handed). Drag the little blue square all the way down to the last cell of column C.


4. Now you can see that all the cells of column C are correctly set as the sum of the corresponding cells in column A and B.

1 comment:

Unknown said...

Yes, but if data is sent from a form, the row is inserted into the existing spreadsheet and the formula does not insert into the new row. I need the formula to automatically apply to the entire column. Any thoughts???

 
Get This <