| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I drag a,b,c,d down a column into a series?
I want to create a list in a column that just uses the alphabet....What
should I do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I drag a,b,c,d down a column into a series?
Hi,
You can use this for lower case letters: =CHAR(96+ROW(A1)) copy down if you want upper case letters then use 64 instead of 96 HTH Jean-Guy "BethfromNJ" wrote: I want to create a list in a column that just uses the alphabet....What should I do? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I drag a,b,c,d down a column into a series?
It's probably better to create a list in alphabetical order with then
letters, then select it, then do toolsoptionscustom lists and import and add it. After that you only have to type in a or A and copy it down and it will return a list -- Regards, Peo Sjoblom "BethfromNJ" wrote in message ... I want to create a list in a column that just uses the alphabet....What should I do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| how do I drag to extend a series across lots of cells quickly? | Excel Discussion (Misc queries) | |||
| XL Charts: Let my mouse drag all data labels for a whole series. | Charts and Charting in Excel | |||
| how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
Linear Mode
