View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

One way ..

Assume you have created the lowercase alpha series:
a, b, c, d ..

Enter the first letter in say B2: a
*Right-click* on the fill handle
(i.e. the bottom right corner of B2)
and drag down to B28

When you release the right-click choose "Fill series"

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Custom series" <Custom wrote in message
...
How do you use cutom series once series has been created?