Here's how to do it:
- Click on the cell where you want the standard deviation to appear.
- For a sample standard deviation, type =STDEV( and choose STDEV.S from the suggested formulas.
- Click on the Column B2 cell to select it and drag the selection point down till the last cell of our data.
- Press Enter to display the calculated standard deviation in the selected cell.