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?
iMac, Mac OS X (10.7)
Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
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
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.
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.
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?