Numbers - formula drag down a cell to increase number by 1

What is the formula to increase a cells number by 1 - in order to make a descending number list from 1 onwards, the way you can do with dates?


In the following snapshot I have tried to grab the yellow dot and copy hoping the next cell will add + 1 .. but all it does is copy the cell?


What is the correct formula to increase the following cell by 1?

MacBook Pro 13″, OS X 10.10

Posted on Aug 18, 2023 3:02 PM

Reply
Question marked as Best reply

Posted on Aug 18, 2023 4:25 PM

Enter the first two values, say 1 and 2. Select those two cells and drag the yellow dot down.


SG

2 replies

Numbers - formula drag down a cell to increase number by 1

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