fill series data

K

Kyoko Yoshino

In Excell 2000, I could fill column or row which has data
with text at the end, i.e. 1a, 2a by dragging fill handler.
However, in Excel 2002, I could not.

When I drag fill handler of columns which has data 1a and
2a, it just repeat 1a and 2a instead of filling data such
as 1a, 2a and 3a.

It is very inconvenient.

Pls advise if someone know if this is a program bug.
 
L

Leo Heuser

You have to use a1, a2 etc. instead of 1a, 2a
etc., i.e. text at the start. Also in Excel 2000.

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 

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