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.
 



