Most excel users are familiar with auto-fitting numeric values in a dataset. However, auto-fitting alphabetical values is not by default available in MS Excel. The procedure below needs to be performed for auto-fitting alphabetical values in MS Excel.
STEP 1] manually type the alphabet letters from A to Z.
STEP 2] Go to File > Options. The “Excel Options” Menu will appear.
STEP 3] In the left hand panel go to Advanced > general. And click on the “Edit Custom Lists” Button.
STEP 4] select the alphabetical range (from A to Z which was created in STEP1).
STEP 5] Click on Import.
STEP 6] Click OK > OK.
The Alphabetic characters will be auto-fitted in your spreadsheet after performing the aforementioned steps.