Autofill a column with increasing numbers

Excel allows one to automatically increment numbers in a column. For example, one can enter the number 1 in the first cell, and then drag downwards to increment from 1 to whatever number you'd like to end with. It saves you having to manually enter cell numbers as you go downwards. I can't find this function in Numbers for Mac. I have a workaround by creating a formula in the cell after the number 1. The formula is quite simply add 1 to the cell containing 1. Copy the formula and paste downwards. Excel made this really easy however and is there any equivalent in Numbers for Mac.

MacBook Pro 13″, macOS 14.1

Posted on Nov 19, 2023 3:58 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 19, 2023 5:24 AM

type "1" in cell A1

type "2" in cell A2


select both cells, then hover the cursor over the bottom edge and drag the yellow dot (the fill control) down as needed.


this technique will work with other patterns.

Odd Numbers:

type "1" in cell A1

type "3" in cell A2



Even Numbers:

type "10" in cell A1

type "12" in cell A2



Cap Letters:

"A"

"B"


"Odd", Cap letters:

"D"

"F"



Dates one week apart

1/1/2024

1/8/2024



Similar questions

1 reply
Question marked as Top-ranking reply

Nov 19, 2023 5:24 AM in response to RichardFosse

type "1" in cell A1

type "2" in cell A2


select both cells, then hover the cursor over the bottom edge and drag the yellow dot (the fill control) down as needed.


this technique will work with other patterns.

Odd Numbers:

type "1" in cell A1

type "3" in cell A2



Even Numbers:

type "10" in cell A1

type "12" in cell A2



Cap Letters:

"A"

"B"


"Odd", Cap letters:

"D"

"F"



Dates one week apart

1/1/2024

1/8/2024



This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Autofill a column with increasing numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.