After calculating standard deviation for one row, how to quickly calculate for other rows?

Conditions

• The formula in the first row uses relative references.
• Adjacent rows have the same positional structure for the data.

Reasoning, step by step

1. Select the cell containing the completed standard deviation formula (e.g., O2).
2. Move the cursor to the bottom-right corner of the cell until it becomes a cross (fill handle).
3. Drag the fill handle down to the target cells (e.g., O3 and O4).
4. Release the mouse to fill the formulas and display the results.

Example

After selecting O2, dragging down the fill handle automatically fills O3 and O4 with results 3.80 and 5.55.

Common misconceptions

• Manually retyping the formula for each row.
• Forgetting that the references must be relative for the automatic adjustment to work correctly.

Watch the explanation

Explore next

• Why don't Kaohsiung and Hsinchu need to re-enter the formula after dragging the N2 formula down?
• Which function should be used in Google Sheets to calculate population standard deviation?