10 Replies Latest reply: Nov 4, 2013 4:48 AM by bzabbia
J Williams Level 1 Level 1 (10 points)
hey guys, i have a cell(call it, E10) with a really simple formula(all references are in the "10" row), very simple. When i try to drag the formula down to (E11) from (E10) it just wont work. I don't get an error, its just like it wont let me drag it down, i don't know why, it works else where on the sheet. Have any idea how to fix it?? Thanks
  • Barry Level 7 Level 7 (29,205 points)
    Hi J,

    Is Row 11 a footer row? You can't fill a cell across a header-body boundary or a body-footer boundary.

    Can you copy E10 and Paste into E11?

    If you enter the formula (from the keyboard) into E11, can you then fill it down using the Fill Handle?

    Regards,
    Barry
  • J Williams Level 1 Level 1 (10 points)
    Hey Barry,
    It's is definitely not a footer row and i can copy and paste and it works just fine. Other cells in the row are able to be dragged down through the other cells in the columns however, this column(probably the least complex of formulas) wont work. Cells to the right and left will drag via handle but this one will not...its weird. Any ideas> Thanks.
  • Barry Level 7 Level 7 (29,205 points)
    Can't even hazard a guess at this point. Does the formula exist in rows above row 10?
    If so, what happens when you try filling the top cell containing the formula down through E10 to E11 (and beyond)?
    If not, what happens if you try to fill it into E9, D10 or F10 (by dragging the fill handle)?

    Regards,
    Barry
  • J Williams Level 1 Level 1 (10 points)
    yes, the formula exists above and it still cant be dragged through. And its very simple like A10 + B10. Something is telling the sheet that that formula can not be reproduced, maybe its just a glitch or something, it has to be, i can overstate the simplicity of the formula. And the fact that others around work, that's whats really throwing me off..
  • Level 8 Level 8 (41,780 points)
    May you check that the cells A11 and B11 exist. Maybe they are merged with an other cell.

    You may also send an example file to my mailbox so I would be able to search more easily what is wrong.

    Click my blue name to get my address.

    Yvan KOENIG (VALLAURIS, France) lundi 31 janvier 2011 10:21:30
  • J Williams Level 1 Level 1 (10 points)
    Thanks guys, Yvan, i sent you an email with the file.
  • Level 8 Level 8 (41,780 points)
    And I answered a few seconds after receiving the file.

    To every users attention :

    When fill down behaves wrongly, check if the column is a coherent one.
    If the group of cells is not a true column but the result of a merge process applied upon the rows which you try to fill down, don't search more. The culprit is the fact that you merged.

    Look at this first screenshot.

    I started from a two rows table.
    I merged D2 and E2
    Then I dragged the bottom left handle to the bottom to create new rows.
    I inserted a simple formula in the cell resulting of the merge process upon D2 and E2
    Fill down doesn't apply.

    Numbers is fair with us.
    Look at this second screenshot.

    I started from a two rows table.
    I inserted a formula in D2
    I merged D2 and E2
    Then I dragged the bottom left handle to the bottom to create new rows.
    The AutoFill feature applied but Numbers took care to un-merge the newly created cells.

    Yvan KOENIG (VALLAURIS, France) lundi 31 janvier 2011 19:03:07
  • J Williams Level 1 Level 1 (10 points)
    Thanks for the help and answers, truly. I certainly do not think this is numbers functioning properly, there should be no reason on couldn't drag a formula down through other cells that are merged in the exact same way. I just can't accept that this makes sense, i think it is subpar. I though numbers is proud of each cell being an "independent" cell. Why then would cells way above the merged cell have anything to do with what's below. I think this is a flaw.
  • Barry Level 7 Level 7 (29,205 points)
    J Williams wrote:
    I certainly do not think this is numbers functioning properly, there should be no reason one couldn't drag a formula down through other cells that are merged in the exact same way. I just can't accept that this makes sense, i think it is subpar...


    Hi J,

    Wrong forum for "should" messages. This is a user-to-user forum, and the people who'll respond to your messages here don't have any direct control over the way things 'should' work, or 'why' things work the way that they do.

    If you want those thngs to change, you need to talk to Apple. The route for that is through the Application menu in most current Apple applications. That's the menu that appears immediately to the right of the blue Apple logo on the menu bar—in Numbers,it's the "Numbers menu.

    Choose the "Provide Numbers Feedback" item, and use the form to state your request. Then cross your fingers and wait at least for the next version of Numbers.

    Regards,
    Barry
  • bzabbia Level 1 Level 1 (0 points)

    Hi,

    The table images for your reply Yvan have been removed from this thread.

    I have a large table (Table A) with some drop boxes and a few simple formulas. The fill down using the drag handle stopped working when I copied data from a similarly structured table (Table B) into table A. I currently have about 700 rows. and don't really want to go back and re-enter data to make it a true column.

    Is there a simple way to transform a merged column back into a true column again, apart from starting from scratch, or re-entering the copied data from Table B into Table A manually?

     

    Regards

    Ben