In Microsoft Excel I type SL No. in one column.
There I use 1,2,3. After type 1,2,3, drag and drop and full fill some rows.
It’s very easy for me. Saturday, Sunday, Monday; January, February is also easy.
But now I need to type a, b, c, d, e in one column with the help of drag and drop column.
How can I complete the task?
Assuming that you have the letter "a" in cell A1, put this formula in cell A2 (without the quotes): "=CHAR(CODE(A1)+1)". You will notice that "b" will be displayed on cell A2.
To increment to other cells, just drag the formula in A2 to the next cells below A2. Take note though that once you reach "z", it will not return to "a". Instead, other characters will appear such as "]","|","[", etc.
I'm sure there are other solutions to your problem but this is probably the simplest and is also the most similar to dragging of cells to auto increment values in MS Excel.
Hi Rebertcarlos,
Although you can do it with the functions char() and code() , you can do it by adding an auto fill list by yourself. In fact, you can customize the auto fill entries to add not only the letters of the alphabet, but anything you can imagine (but of course there must be some logic on this) that would make your life easier with auto fill.
On your worksheet,
1. Click the Office button Â
2. Click Excel Options
3. Create lists for use in sorts and fill sequences by clicking Edit Custom List.
4. Click Add. Type the letters of the alphabet from a to z separated with commas. (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,w,x,y,z)
5. Click ok.
Now you can use your custom auto fill in you worksheet.
In addition, unlike using the formula and function such as CHAR() AND CODE(), immediately after "z", auto fill automatically starts at "a"
Hope this helps.
Regards.
Hi Rebertcarlos
Check out this Techyv post too to get more idea to fix this issue.
