Numbers
How do I put in a column of ascending numbers?
iMac 21.5″, macOS 12.6
How do I put in a column of ascending numbers?
iMac 21.5″, macOS 12.6
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.
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
Numbers