Cody,

Replace the second Q1 with Q5, then select the two cells with Q4 / Q5, and drag the fill handle
down.

HTH,
Bernie
MS Excel MVP


"Cody6111" wrote in message
...
I am attempting to fill a series from A1-R1. I have not noticed it until
today but when I pull this series down past A4-R4, the "Q" series stars
duplicating the Q1-Q$ and will not follow the same series format...how can I
fix this?