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
Sort By: 
Question marked as ⚠️ Top-ranking reply

Jul 23, 2011 7:54 PM in response to Netimoon

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

Reply

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

Reply

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.

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.