Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Fill/Sequential Numbering
Hello,
I am trying to use the autofill feature to drag the letters for sequential numbering/lettering. It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for letters it is just copying. For instance, I have A in cell A1 B in cell A2 C in cell A3 and then I want to highlight and drag down so that D is in A4 E is in A5 F is in A6 Do I need to change an option to get this to work? Thank you, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Fill/Sequential Numbering
Highlight cells A1 to A3 and then drag down.
or Highlight A1, then hold Ctrl and drag down. Both should work. "tjh" wrote: Hello, I am trying to use the autofill feature to drag the letters for sequential numbering/lettering. It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for letters it is just copying. For instance, I have A in cell A1 B in cell A2 C in cell A3 and then I want to highlight and drag down so that D is in A4 E is in A5 F is in A6 Do I need to change an option to get this to work? Thank you, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Fill/Sequential Numbering
Enter the sequence in Tools/Options/Custom Lists (e.g., A,B,C,...,Z)
In article , tjh wrote: Hello, I am trying to use the autofill feature to drag the letters for sequential numbering/lettering. It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for letters it is just copying. For instance, I have A in cell A1 B in cell A2 C in cell A3 and then I want to highlight and drag down so that D is in A4 E is in A5 F is in A6 Do I need to change an option to get this to work? Thank you, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Fill/Sequential Numbering
tjh,
Tools/Options custom lists... Make one A thru Z, and modify as needed... Beege "tjh" wrote in message ... Hello, I am trying to use the autofill feature to drag the letters for sequential numbering/lettering. It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for letters it is just copying. For instance, I have A in cell A1 B in cell A2 C in cell A3 and then I want to highlight and drag down so that D is in A4 E is in A5 F is in A6 Do I need to change an option to get this to work? Thank you, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Fill/Sequential Numbering
Oops ... misread you posting so ignore my crass reply!
"Toppers" wrote: Highlight cells A1 to A3 and then drag down. or Highlight A1, then hold Ctrl and drag down. Both should work. "tjh" wrote: Hello, I am trying to use the autofill feature to drag the letters for sequential numbering/lettering. It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for letters it is just copying. For instance, I have A in cell A1 B in cell A2 C in cell A3 and then I want to highlight and drag down so that D is in A4 E is in A5 F is in A6 Do I need to change an option to get this to work? Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data tracking and auto sequential numbering | Excel Worksheet Functions | |||
Auto Numbering | Excel Worksheet Functions | |||
Auto Numbering | Excel Worksheet Functions | |||
Auto Numbering | New Users to Excel | |||
Auto page numbering for several worksheets | Excel Worksheet Functions |