Skip navigation

Adding numbers to a chart

184 Views 1 Reply Latest reply: Oct 29, 2012 5:28 PM by Jerrold Green1 RSS
Donald Ross Level 1 Level 1 (15 points)
Currently Being Moderated
Oct 29, 2012 3:40 PM

I have created this in Pages, there is more to it than this but this screen shot illisytrates what I am trying to do. I want to add digits from 1 to 96 in the first column, how can I do this ?

 

Screen shot 2012-10-29 at 3.34.17 PM.png

MacBook Pro (17-inch Core 2 Duo), Mac OS X (10.6.8)
  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Oct 29, 2012 5:28 PM (in response to Donald Ross)

    Hi Donald,

     

    There are different ways to add the numbers depending on how you plan to use them. If you want the numbers to stay with the row position (first contact always has the number "1") then you can use the formula: =ROW()-1

     

    The "-1" accounts for the header row.

     

    If you want the numbers to stay with a particular contact even if the rows are sorted or otherwise disturbed, use the Fill tool. Enter a 1 for the first contact and a 2 for the second contact. Select both and then grab the little circle in the lower right corner and drag it down.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.