Help Fill Series

Discussion in 'Excel' started by Mark, Apr 4, 2013.

  1. Mark

    Mark

    Joined:
    Apr 4, 2013
    Messages:
    1
    Likes Received:
    0
    Hello, Any help appreciated,

    I created a sheet a few days ago and added a formula the dragged the formula down the sheet. All good so far the Fill series worked fine.

    Ive now come back to the sheet and I'm trying to extend the formula down another 30 cells and it won't allow me to fill series??

    Ive tried copy & Pasting it, Dragging it. CRTL Drag and the Fill series option is greyed out?

    Any Ideas anyone Please.

    Thanks
    This is the formula i'm dragging the 1555 is the reference that should increment.

    =INDIRECT(ADDRESS(1555,($EM$4*7)))
     
    Mark, Apr 4, 2013
    #1
    1. Advertisements

  2. Mark

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Mark, If you're still alive and kicking, would you mind uploading the sheet? I'll await your response from my cryogenic chamber. I've set it to wake me in 2019.
     
    XLPadawan, Jun 16, 2016
    #2
    Becky likes this.
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. build

    maths help

    build, May 1, 2011, in forum: Excel
    Replies:
    2
    Views:
    723
    XLPadawan
    Jun 16, 2016
  2. bookerk2

    help with conditional formatting

    bookerk2, May 4, 2011, in forum: Excel
    Replies:
    1
    Views:
    661
    XLPadawan
    Jun 16, 2016
  3. jsduiahd
    Replies:
    0
    Views:
    599
    jsduiahd
    Jul 26, 2011
  4. Nago
    Replies:
    0
    Views:
    532
  5. Catw0327

    Timebase help!!!

    Catw0327, Apr 10, 2012, in forum: Excel
    Replies:
    1
    Views:
    694
    XLPadawan
    Jun 16, 2016
  6. caziscarol

    Excel help recording hours

    caziscarol, Oct 27, 2013, in forum: Excel
    Replies:
    1
    Views:
    517
    chimpytech
    Apr 12, 2014
  7. Peter Kaufmann

    Lookup Function Help

    Peter Kaufmann, Nov 8, 2014, in forum: Excel
    Replies:
    1
    Views:
    358
    Peter Kaufmann
    Nov 13, 2014
Loading...