Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AutoFill A to Z
There is an Option in Excel to AutoFill
Like want to Autofill Sunday ,Monday or January, February Or 1,2,3 like this Is it Possible to Autofill A,b,c,d,e and on in a Column or row Or I have type Manually Thanks Hardeep kanwar |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AutoFill A to Z
You ned to create a CUSTOM LIST...
Excel 2003 Tools-Options-Custom Lists tab You can enter this in A1 =CHAR(64+ROW()) copy down till Row 26, copy & paste special as values and then import into a custom list... I could not create both A,B,C and a,b,c, at the same time through import method... "Hardeep kanwar" wrote: There is an Option in Excel to AutoFill Like want to Autofill Sunday ,Monday or January, February Or 1,2,3 like this Is it Possible to Autofill A,b,c,d,e and on in a Column or row Or I have type Manually Thanks Hardeep kanwar |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AutoFill A to Z
Dear Hardeep
To populate the series in a column starting from row 2 use =CHAR(ROW()+63) To populate the series in a row starting from col 2 use =CHAR(COLUMN()+63) Adjust the character code to make it between 65 and 90. If this post helps click Yes --------------- Jacob Skaria "Hardeep kanwar" wrote: There is an Option in Excel to AutoFill Like want to Autofill Sunday ,Monday or January, February Or 1,2,3 like this Is it Possible to Autofill A,b,c,d,e and on in a Column or row Or I have type Manually Thanks Hardeep kanwar |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AutoFill A to Z
WOW..... So Simple
Thanks Sheeloo "Sheeloo" wrote: You ned to create a CUSTOM LIST... Excel 2003 Tools-Options-Custom Lists tab You can enter this in A1 =CHAR(64+ROW()) copy down till Row 26, copy & paste special as values and then import into a custom list... I could not create both A,B,C and a,b,c, at the same time through import method... "Hardeep kanwar" wrote: There is an Option in Excel to AutoFill Like want to Autofill Sunday ,Monday or January, February Or 1,2,3 like this Is it Possible to Autofill A,b,c,d,e and on in a Column or row Or I have type Manually Thanks Hardeep kanwar |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AutoFill A to Z
Thanks Jacob
"Jacob Skaria" wrote: Dear Hardeep To populate the series in a column starting from row 2 use =CHAR(ROW()+63) To populate the series in a row starting from col 2 use =CHAR(COLUMN()+63) Adjust the character code to make it between 65 and 90. If this post helps click Yes --------------- Jacob Skaria "Hardeep kanwar" wrote: There is an Option in Excel to AutoFill Like want to Autofill Sunday ,Monday or January, February Or 1,2,3 like this Is it Possible to Autofill A,b,c,d,e and on in a Column or row Or I have type Manually Thanks Hardeep kanwar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill | Excel Discussion (Misc queries) | |||
Autofill | Excel Worksheet Functions | |||
Can autofill do this? | Excel Discussion (Misc queries) | |||
Autofill | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |