How to create a formula for every row in a column in Google SpreadSheet?
Problem
I use three columns. A, B and C. In column C I have a formula every row and then for the next row I have in C2. How can I do so I don't have to type in the new formula in column C for every row? I use it in both Google Docs SpreadSheet and OpenOffice SpreadSheet.
Error Output
=A1*(1.6*B1)
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: How to create a formula for every row in a column in Google SpreadSheet?
Using the Mouse Click the cell whose formula you want to repeat A dark square "handle" will appear in the lower right corner Click and drag that handle, dragging down the column (or right across the row). You can also double click the handle to auto-fill. Stop at the last cell you wish to fill Using the Keyboard Move the cursor to the cell whose formula you want to repeat Hold While holding, press repeatedly to select the rest of the range of cells you want to fill When you reach the bottom, re…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix