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

Question:

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

Reply

Jul 23, 2011 7:54 PM in response to Netimoon 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

Jul 23, 2011 7:54 PM

Reply Helpful (4)

Jul 24, 2011 12:33 AM in response to Netimoon 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

Jul 24, 2011 12:33 AM

Reply Helpful
User profile for user: Netimoon

Question: How do I increase numbers +1 by draging?