Numbers
How do I put in a column of ascending numbers?
iMac 21.5″, macOS 12.6
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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