Need help

  • Thread starter Thread starter Rithy Chhan
  • Start date Start date
R

Rithy Chhan

Hello all,

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

Thanks

Rithy
 
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
 
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
 
You could use a formula like:

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

And drag down.

But don't go past 26 rows.
 
Back
Top