Skip navigation

Can I make autocompletion for merged cells?

287 Views 6 Replies Latest reply: Jan 17, 2013 5:24 AM by Jerrold Green1 RSS
Dmitry Bilibin Calculating status...
Currently Being Moderated
Jan 16, 2013 4:41 AM

Hi!

Can I make autocompletion for merged cells?

MacBook Pro with Retina display, OS X Mountain Lion (10.8.2)
  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Jan 16, 2013 7:05 PM (in response to Dmitry Bilibin)

    Yes, it can be done.  I assume you don't yet have Numbers, otherwise you would have tried it and discovered the answer.

     

    Here is an example with a horizontally merged cell

     

    Screen Shot 2013-01-16 at 10.01.01 PM.png

     

    Here is an example with a vertically merged cell

     

    Screen Shot 2013-01-16 at 10.01.13 PM.png

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Jan 16, 2013 11:50 PM (in response to Dmitry Bilibin)

    Hi Dmitry,

     

    Seems to be working to me. Numbers is incrementing the value by one in each new cell in the column.

     

    But after trying it, I suspect that the ability to auto fill in this manner is, as you've noticed, restricted to unsplit rows.

     

    Regards,

    Barry

  • Yellowbox Level 4 Level 4 (3,920 points)
    Currently Being Moderated
    Jan 17, 2013 3:53 AM (in response to Dmitry Bilibin)

    Hi Dmitry,

     

    I have tried inserting a formula in merged Cells 4/5

     

    =A2+1

     

    to add another day to the date. That worked, but I could not Fill Down, either by dragging or by Shift-Click, Insert Menu >  Fill Down.

     

    My friend, you are stuck!

     

    I do not use merged cells. In my opinion, they are a device to make a pretty layout but cause problems in data management.

     

    Start again (ouch!) and try this:

     

     

    Date

    Line

    Fruit

    17/01/13

    1

    Apples

    17/01/13

    2

    Oranges

    18/01/13

    1

    Apples

    18/01/13

    2

    Oranges

    19/01/13

    1

    Apples

    19/01/13

    2

    Oranges

     

    Each Row is a unique record.

     

    I hope this helps.

     

    Ian.

  • Jerrold Green1 Level 7 Level 7 (28,200 points)
    Currently Being Moderated
    Jan 17, 2013 5:24 AM (in response to Dmitry Bilibin)

    Dmitry,

     

    In A4, write: =A2 +1

     

    Copy cell A4

     

    Select cells A6 through the bottom of your range

     

    Command-V to Paste the expression to the range, completing your date series.

     

    Regards,

     

    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.