Skip navigation

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 cells

296 Views 6 Replies Latest reply: May 2, 2012 10:28 AM by Barry RSS
zshell Calculating status...
Currently Being Moderated
May 1, 2012 2:39 PM

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
  • Wayne Contello Level 6 Level 6 (12,665 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

  • Wayne Contello Level 6 Level 6 (12,665 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

  • Barry Level 7 Level 7 (29,095 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

  • Barry Level 7 Level 7 (29,095 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.

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.