CODEWITHSUNDEEP
excellibreoffice-calc
Javier Arias
Javier Arias

Reputation: 2478

How to automatically number columns in calc/excel

In spreadsheet software such as LibreOffice Calc, or MS Excel, rows are numbered starting at 1, and column identifiers are assigned with a letter (A, B, C, etc.).

Is it possible to add an extra row and enumerate all columns progamatically like in the picture below?

enter image description here

Upvotes: 2

Views: 288

Answers (1)

pnuts
pnuts

Reputation: 59450

=COLUMN()

in either, or switch Excel Options (Formulas, Working with formulas in Excel 2013) to R1C1 reference style.

Upvotes: 3

Related Questions