Fill / Series / Alpha

C

carl

I would like to fill a series like this:

AB,AC,AD....AZ.

Is there a function that will do this for me ?

Thank you in advance.
 
R

RagDyeR

If you do it once, manually, you could then add it to your "Custom Lists",
and it would become automatic from there on.

Create the list and select it, then:

<Tools> <Options> <CustomLists>

The "Import" box should already contain the range of the list, since you had
selected it.
Just click <Import> <OK>.

You now have the ability to drag and fill.

While you're at it, it might pay to create a list for the alphabet.

Never understood why Redmond didn't include this as a default.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to fill a series like this:

AB,AC,AD....AZ.

Is there a function that will do this for me ?

Thank you in advance.
 

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