Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series with alphabetic
hi community
can community assist me in this task, i wanted to fill series, say, I place alphabet letter, "a", in one cell and when I drag downwards or sideways, it will display, say, I drag away with 5 cells, it will display, a b c d e f... is this possible? i tried using the Series dialog box on "linear" , "Growth", it does not work??? or is it not possible to do such action, cause Excel only able to do with numeric data? thanks community for the assistance given :) -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series with alphabetic
in A1:
=CHAR(ROW()+96) then copy down |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series with alphabetic
10s! :) Jarek Kujawa much appreciated
thanks community as well :) -- oldLearner57 "Jarek Kujawa" wrote: in A1: =CHAR(ROW()+96) then copy down |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series with alphabetic
Check out these old posts.
The first describes how to set-up A to Z. The second describes how to go beyond Z, to AA, AB, AC ... to maybe SA, SB, SC ... etc. http://groups.google.com/group/micro...5911fc66478752 http://groups.google.com/group/micro...8a0b7118ec0725 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "oldLearner57" wrote in message ... 10s! :) Jarek Kujawa much appreciated thanks community as well :) -- oldLearner57 "Jarek Kujawa" wrote: in A1: =CHAR(ROW()+96) then copy down |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
How can I fill alphabetic series in excel | Excel Discussion (Misc queries) | |||
Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
Fill Series | New Users to Excel | |||
Fill series but a little different | Excel Discussion (Misc queries) |