Need help

[Rithy Chhan]

Hello all,

If I have list of 1a, 1b, 1c (in different cells). Can I drag to get 1d,
1e,.......

Thanks

Rithy

 

[Bill Ridgeway]

Yes. Highlight the last two cells and, in the bottom right you will see a
small black blob. Catch hold of this and drag it and the value of the
increment between the two cells will be copied to those cells.

If this doesn't work it will be because it needs to be configured. Click on
<Tools><Options><Edit> and tick <Allow cell drag and drop>.

Regards.

Bill Ridgeway
Computer Solutions

 

[Rithy Chhan]

I try this, but it shows only 1a, 1b, 1c, 1b, 1c, 1b, 1c.....
but I would like it is in order: 1a, 1b, 1c, 1d, .....1x, 1y, 1z

Thanks

 

[Dave Peterson]

You could use a formula like:

="1"&CHAR(ROW(A1)+96)

And drag down.

But don't go past 26 rows.

 

[Rithy Chhan]

Thanks, it works.

You could use a formula like:

="1"&CHAR(ROW(A1)+96)

And drag down.

But don't go past 26 rows.