Fill series Q1, Q2, Q3, Q4

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
Cody,

Sorry, but I don't know of any way to disable this feature.

HTH,
Bernie
MS Excel MVP
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill in Excel 2003 problem 2
Series fill only copying and fill series greyed out 1
3 out of 5? 5
Line chart - Series designation 1
How to distribute/spread/map cost of project across different year 3
Excel Fill issue 2
fill time seiries to plot 1
Transforming sheet1 rows into a single sheet2 col 1

Back
Top