Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I increase numbers +1 by draging?

In MS Excel, you can just ctrl + drag cells to increase numbers by +1.


How can I do the same thing in Numbers?


User uploaded file

iMac, Mac OS X (10.7)

Posted on Jul 23, 2011 2:56 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 23, 2011 7:54 PM

In Numbers, seed the series by entering 1 in the first position and 2 in the second position. Select both cells and drag the Fill Handle to extend the range. The Fill Handle is a little circle in the lower right corner of the selction.


Jerry

2 replies

Jul 24, 2011 12:33 AM in response to Netimoon

Adding to what Jerry said:


Numeric values will increment in steps set by the two seed values.

Single letters, text strings ending with a (single) numeral, times and dates will increment from a single seed, as shown below. Green filled cells are the seed values.

User uploaded file

With two seed values, items in the first six columns in the example can also be made to increase (or decrease) in other than single unit steps. Add a third seed value (that breaks the pattern), and you'll get results like those in the last two columns.

User uploaded file

This, and other topics about Numbers are covered in the Numbers '09 User Guide. This guide and the iWork Formulas and Functions User Guide are available for download through the Help menu in Numbers.


Regards,

Barry

How do I increase numbers +1 by draging?

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