Auto fill / Drag and drop in Microsoft Excel

Asked By 30 points N/A Posted on -
qa-featured

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.

drag and drop and full fill some rows

How can I complete the task?

SHARE
Best Answer by Wally_West
Best Answer
Best Answer
Answered By 0 points N/A #111397

Auto fill / Drag and drop in Microsoft Excel

qa-featured

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.

Answered By 0 points N/A #111398

Auto fill / Drag and drop in Microsoft Excel

qa-featured

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,

customize the auto fill entries

1. Click the Office button   

2. Click Excel Options

3. Create lists for use in sorts and fill sequences by clicking Edit Custom List.

using the formula and function

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.

Login/Register to Answer

Related Questions