6 Replies Latest reply: May 2, 2012 10:28 AM by Barry
zshell Level 1 Level 1 (0 points)

My apologies to the two people that replied to my question re Numbers. I was not specific enough... If I had a single column of 100 empty cells and I wanted to number each cell, starting with  1  , and then increasing the number one increment to cell 100, how would I do it without having to type into each individual cell?

 

AppleWorks spreadsheet made it very simple.


iMac
  • 1. Re: My apologies to the two people that replied to my question re Numbers. I was not specific enough... If I had a column of empty 100 cells and I wanted to number each cell by increasing the number 1 increment, how would I do it without typing into eac c
    Wayne Contello Level 6 Level 6 (13,615 points)

    enter "1" in cell A1, then "2" in cell A2

    Screen Shot 2012-05-01 at 4.43.39 PM.png

     

    then select cells A1 and A2

    Screen Shot 2012-05-01 at 4.44.15 PM.png

     

     

    then grab (click and hold) the little circle at the bottom rigth of the selection:

    Screen Shot 2012-05-01 at 4.44.54 PM.png

     

    then drag down as needed

    Screen Shot 2012-05-01 at 4.45.39 PM.png

    then release the mouse button

     

     

    The Numbers Users' Guide is your friend:

    http://support.apple.com/manuals/#numbers

  • 2. Re: My apologies to the two people that replied to my question re Numbers. I was not specific enough... If I had a column of empty 100 cells and I wanted to number each cell by increasing the number 1 increment, how would I do it without typing into eac c
    Wayne Contello Level 6 Level 6 (13,615 points)

    another way is to place the formula:

     

    A1: "=row()"

     

    then select A1 and fill down.  So long as all cells in column A are the same this will auto fill even when you insert rows or expand the table

  • 3. Re: My apologies to the two people that replied to my question re Numbers. I was not specific enough... If I had a column of empty 100 cells and I wanted to number each cell by increasing the number 1 increment, how would I do it without typing into eac c
    zshell Level 1 Level 1 (0 points)

    Wayne, really appreciate your trying to help me. Have tried both your suggestions without success. I am using Numbers '09, version 2.0.5, on iMac OS X 10.6.7. I am an experienced user... in fact I teach Fundamentals & Basics at our Learning Center here in our retirement community. You might find my monthly columns of some interest...   www.themacclub.org    L.C. Editorials.

     

    I mention all this because I am not a dumbfeces... but this Numbers app has some features I am not able to tap into. Another feature I need help with is a Library List I maintain. In AppleWorks it was a cinch to show the List in numerical order, and then use the Category column to rearrange the List for reference by Category. Can Numbers do that... and how?

     

    Thanks for your time....

    shell

  • 4. Re: My apologies to the two people that replied to my question re Numbers. I was not specific enough... If I had a column of empty 100 cells and I wanted to number each cell by increasing the number 1 increment, how would I do it without typing into eac c
    Barry Level 7 Level 7 (29,180 points)

    Hi Shell,

     

    The default "Blank" template in Numbers produces a sheet containing a table that has one header column (column A) and one header row (row 1).

     

    Header rows and columns have several useful features, at least one of which (header rows are not included in sorts) you'll likely find useful in your Library list project.

     

    The property that is probably the one preventing your using either of Wayne's suggested techniques is this: You can't Fill down across the boundary between a Header row and an ordinary row.

     

    Since your Header row is usually used to contain column labels, rather than a list record, you should start your numbering in row 2. The instructions below are for numbering the cells in Column A.

     

    Method 1 (Seed, then drag to fill):

    • Enter 1 in cell A2
    • Enter 2 in cell A3
    • Select both cells (Click on A2, command-click on A3)
    • Hover the mouse over the Fill control (small circle shown in Wayne's post).
    • When the pointer turns to a black + sign, press the (left) mouse button and drag the control down (to row 101).
    • When '100' is seen in cell A101, release the mouse button.

     

    Method 2 (Formula):

    • Start with a table that has 101 rows.
    • In cell A2, enter the formula:   =ROW()-1
    • You'll see the result (1) in the cell.
    • Click the Column reference tab for column A to select the whole column.
      -- If cell A1 has been included in the selection, command-click that cell to remove it from the selection.
    • Go Insert (menu) > Fill > Fill Down.
      -- The formula will be filled down to all of the cells in column A, and the calculated results displayed.

      Important step follows:

    • With the column still selected:
      Copy (command-C, or Edit > Copy), then go Edit > Paste Values.


      This step replaces the formulas with the calculated values, making it possible to re-sort the table into its current order. If the formula were left in the cells, Numbers would immediately recalculate after a sort, producing a new set of ordered numbers in this column.

     

     

    Regarding sorting your Library List:

     

    Yes, Numbers can do this. A Numbers table can be sorted on the data in any column. The model is a database one, which considers each row as a record, and keeps the rows together when sorting.

     

    To sort, click the Reorganize button in the toolbar above the document workspace, the choose the column on which to sort. If you have used a Header row, the columns will be identified (in the popup menu in the Reorganize window) by the labels in that row.

     

    To sort by categories, then do a subsort by author within each category:

    • Click the Reorganize button.
    • In the Sort section, choose the Categories column, then click the + sign to the right to add a subsort.
    • In the second sort line, choose the Authors column.
      More than one item by each author? Add a second subsort (by title).

    To return the table to it's original order (assuming you've numbered the rows in column A)

    • Click the Reorganize button. The window will open with your most recent sort rules showing.
    • From the popup in the first sort line, choose column A.

     

    Done. Since there's only one row with each number, the two subsorts will have no effect.

     

    Regards,

    Barry

     

    PS: I'd strongly recommend spending some time reading at least the first few chapters of the Numbers '09 User Guide. The guide may be downloaded via the Help menu in Numbers.

    If you'll be writing formulas in Numbers, you'll also want to download the iWork Formulas and Functions User Guide. You'll use this more as a reference manual for the functions supported by Numbers (and the other iWork applications).

    B

  • 5. Re: My apologies to the two people that replied to my question re Numbers. I was not specific enough... If I had a column of empty 100 cells and I wanted to number each cell by increasing the number 1 increment, how would I do it without typing into eac c
    zshell Level 1 Level 1 (0 points)

    Barry... excellent instructions. Thank you.

     

    shell

     

    P.S. One more request, if you will. Folks at Apple stores have not been able to give me guidance on this one. Again in Numbers... I would like to isolate a dozen cells that appear in a large spreadsheet and print only those images. In AppleWorks it was easy to do when highlighting the cells and entering the correct print range. Is such a feature available in Numbers? I do use a couple of work-arounds to accomplish this task but am curious about doing it using Numbers.

  • 6. Re: My apologies to the two people that replied to my question re Numbers. I was not specific enough... If I had a column of empty 100 cells and I wanted to number each cell by increasing the number 1 increment, how would I do it without typing into eac c
    Barry Level 7 Level 7 (29,180 points)

    Hi shell,

     

    Easiest method, and possibly one of the one's you are already using, is to:

     

    • Select the block of cells*
    • Copy
    • Launch Preview
    • Press command-N (or go File > New from Clipboard
    • Print.

     

    Staying within Numbers, you could:

     

    • Select the block of cells*
    • Copy
    • Click the Sheet button to add a sheet to the document.
    • Select the icon of the table added with that sheet, press delete to delete that table.
    • Click in the now-empty sheet.
    • Paste to create a new table containing only the copied cells.
    • Print, specifying that only that page is to be printed.

     

    Minor difficulty with this method is determining which 'page' that new table is on. To do so, go View > Show Print view, then check the page number(s) displayed at the bottom left corner of the document window.

     

    Your question specifies "images." If by this you mean that the dozen cells 'contain images', then a third method—transferring a copy of the data to a separate 'breakout table' won't work. Images may be inserted into cells only as an 'image fill' in the cell background. The background isn't treated as 'content', so it won't be transferred using a formula, as formulas deal only with the content of the cell.

     

    Regards,

    Barry

     

    *A selection of individual, scattered cells will work as well. The result will be a rectangular table showing only the data in the selected cells; the rest of the cells necessary to make a rectangular block to contain the selected cells (in their original locations relative to each other) will be included, but will be blank.