how do i change the sequence of numbering in auto fill? instead of 1,2,3... can i get 1,1,2,2,3,3... or 1, , ,2, , ,3?
Language (or Software): Excel
Hello and welcome to Just Answer. My name is XXXXXX XXX I will assist you with your question
Are the commas required or just the values?
In your first example are the commas required or just the values?In your second example are the commas required or do they represent blank cells?
In your second example, if the commas represent blank cells between the values, you can do the following: in A1 type 1 A2 leave blank A3 leave blank in A4 type 2 A5 leave blank A6 leave blank highlight A1 through A6 drag and copy fill handle down Please let me know if this is what you are needing.
the comma's are just separators in both instances. your second example works for blank cells between values.
Microsoft Certified and 14 years teaching Microsoft Office to corporate and residential
I will gladly show you how to achieve your first example.if you you would like. If so, don't start a new question, just post it here and I will add it 41077.0768837963