Fill series alphabetically

Dear Cat

Thank you for attending Excel 2007 Advanced course!! I hope you enjoyed the course and benefited from it.

The fill series works because they are normally entered into the custom list.

Unfortunately the Alphabets are not normally in that list but you can follow these steps to add them to the custom list so next time when you Type in A and then use the Fill handle to drag the other letters will appear automatically!

1. Choose Office Button and then Excel Options.

2. In eth Popular sections click the Edit custom lists... button

3. Ensuring that you are on New List on the right hand pane copy and paste the following:
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z.

4. Press Add Button

5. Press OK to close the Edit Custom List dialog box

6. Press OK again to close the Excel Options dialog box

7. Try by trying any Letter and then dragging the fill handle down should give you the remaining letters that you want!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT