Click the blank cell in a new column in your spreadsheet
2
Begin the formula with the = sign
3
Type in the formula
4
Click and drag the blue circle to copy the formula to all the cells
5
With the student numbers selected, right click and choose copy.
Well done!
Create how-to guides like this in a snap. Get Tango now.
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key
