ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using Custom Series (https://www.excelbanter.com/excel-worksheet-functions/6608-using-custom-series.html)

Custom series

Using Custom Series
 
How do you use cutom series once series has been created?

Max

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?




JulieD

Hi

type anyone of the entries in the custom list in a cell, move the cursor
over the bottom right of the cell until you see a +, hold down you left
mouse button and drag to where you want it to fill to & let go.

Cheers
JulieD

"Custom series" <Custom wrote in message
...
How do you use cutom series once series has been created?





All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com