|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 28th, 2009, 05:44 PM
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
March 28th, 2009, 06:09 PM
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
March 29th, 2009, 05:48 AM
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
March 29th, 2009, 07:56 AM
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
March 29th, 2009, 07:59 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
