Numbers

Hi Sara,

If you want to create a column of ascending numbers,

Method 1.

Insert 1 into the first cell.

in the second cell, use a formula to add 1

Fill down

Method 2.

Insert 2 starting numbers. Select them both and drag the yellow dot (fill handle) down.

Other examples of filling down:

Regards,

Ian.

Enter the numbers in the column, then go to the column letter at the top and choose 'Sort Ascending' from the dropdown.

SG