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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.