I am trying to series fill linked cells from sheet 1 to sheet 2 but when i copy the first cell and link it ( sheet 1 $a$7) and try to series fill to the next columns it dose not offer to series fill just lets you copy