Calc - create alpha-numeric series

How do I create an alpha-numeric series.
For example, if I have M11 in row 21 then I want M12 to be inserted automatically in row 22.

I know how to create a numeric series using the formula =ROW(A1)


  • If you require a formula: ="M" & ROW()-10 to start your series in row 21 with M11 and copy down.
  • If you need fixed values: Write M11 into the cell and drag down on the small square in the right lower corner of the cell to the row, where you want your series to be finished (The number gets auto-incremented)

Tested using LibreOffice:

Version:, Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kf5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

Hope that helps.

If the answer helped to solve your problem, please click the check mark (:heavy_check_mark:) next to the answer.

Many thanks for this Answer – problem solved.

Many thanks for this Answer – problem solved.

Aha - and why did you remove the check mark (:heavy_check_mark:) if it helped you once?

I did not intend to REMOVE the check mark (:heavy_check_mark:).

If it doesn’t have to be a formula then just enter M11 in a cell and pull the bottom right cell border handle down, which creates M12, M13, …