Cat has attended:
Excel Advanced course
Fill series alphabetically
When I wish to fill down a series of numbers ie 1,2,3 etc I can just hold my right mouse button down and drag the cursor to the required end point, then select Fill Series from the menu.
How is this done with regard to the alphabet, ie A, B, C etc?
Thanks for your help
Cat
RE: 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
