View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cody6111 Cody6111 is offline
external usenet poster
 
Posts: 2
Default Fill series Q1, Q2, Q3, Q4

The asnwer definelty makes it easier to deal with the problem, but is there a
way to completely resolve the problem. Is there a setting that can be changed
to keep the Qs replicating in the same manner as all the other letter/number
combinations on the fill cells.

"Bernie Deitrick" wrote:

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?