Series fill in Excel 2003 problem


T

Tony Vella

I am using Excel 2003 on a Win 7 machine. I am a stamp-collector and I
am preparing lists of stamps I have to be able to take with me to the
stamp club as spreadsheets rather than carrying 10 pounds of catalogs.

My catalog identifies Parcel Post stamps by adding the capital letter
"Q" before the number, i.e. Q1, Q2, etc. When I insert Q1 in cell A1
and Q11 in cell A2 and then right-drag and "fill series" for ten
columns, the second row is shown accurately as Q11 to Q20 but row 1
shown as Q1, Q2, Q3, Q4, Q1, Q2, Q3, Q4, Q1, Q2 as if the software is
reading the Qs as quarters. So far I have had to enter Q5 to Q10
individually by hand by I would prefer to solve this minor problem once
and for all.

Any help appreciated in advance.
 
Ad

Advertisements

V

Victor Delta

Tony Vella said:
I am using Excel 2003 on a Win 7 machine. I am a stamp-collector and I am
preparing lists of stamps I have to be able to take with me to the stamp
club as spreadsheets rather than carrying 10 pounds of catalogs.

My catalog identifies Parcel Post stamps by adding the capital letter "Q"
before the number, i.e. Q1, Q2, etc. When I insert Q1 in cell A1 and Q11
in cell A2 and then right-drag and "fill series" for ten columns, the
second row is shown accurately as Q11 to Q20 but row 1 shown as Q1, Q2,
Q3, Q4, Q1, Q2, Q3, Q4, Q1, Q2 as if the software is reading the Qs as
quarters. So far I have had to enter Q5 to Q10 individually by hand by I
would prefer to solve this minor problem once and for all.

Tony

If you manually insert Q5 you will find the rest follow ok with the drag
handle.

However, better still, enter Q1 to Q10 in adjacent cells and highlight them.
The go to Options, Custom Lists, and Import the data into the List entries,
and click OK. From now on you will be able to drag down from Q1 and your
problem is solved.

Hope this helps,

V
 
Ad

Advertisements

T

Tony Vella

Tony

If you manually insert Q5 you will find the rest follow ok with the drag
handle.

However, better still, enter Q1 to Q10 in adjacent cells and highlight
them. The go to Options, Custom Lists, and Import the data into the List
entries, and click OK. From now on you will be able to drag down from Q1
and your problem is solved.

Hope this helps,

V
Hi Victor.

Sorry for the delay in replying; I went and spent a few days in
Montreal. I followed your advice and it worked like a charm. Thank you
very much.

Regards.
 

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

Top