I'm trying to fill cells across a row. The first cell references C18, the
next F18, the one after that I18 and so on i.e two cell are to be skipped to
get to the next value I want. However, after i fill the first 3 values
manually and drag the fill handle after selecting all three the next value to
be filled in is F18, then I18, L18, I18 and so on. Is there a way to make the
fill follow the series I want it to?
The problem persists even if I fill 5 cell manually.