Auto fill / Drag and drop in Microsoft Excel

Asked By rebertcarlos 30 points N/A Posted on - 08/08/2011

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?

• Status: Open
• Question Views: 1844
• Answer Count: 3
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Wally_West

Go To Solution

Best Answer

Best Answer

Answered By Wally_West 0 points N/A #111397

Auto fill / Drag and drop in Microsoft Excel

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.

About Wally_West

Questions
0

Answers
20

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 08/08/2011
• Question Category: MS Excel

Answered By jomar05 0 points N/A #111398

Auto fill / Drag and drop in Microsoft 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.

About jomar05

Questions
1

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/08/2011
• Question Category: MS Excel

Answered By David E Cooper 0 points N/A #111399

Auto fill / Drag and drop in Microsoft Excel

Hi Rebertcarlos

Check out this Techyv post too to get more idea to fix this issue.

Setting up an 'autocomplete script excel'

About David E Cooper

Questions
8

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/17/2014
• Question Category: MS Excel