Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to navigation Jump to search
This page is a translated version of the page Faq/Calc/148 and the translation is 0% complete.
Other languages:
Deutsch • ‎English • ‎Nederlands • ‎español • ‎français • ‎italiano • ‎čeština • ‎русский • ‎日本語

How to have the columns numerically instead of alphabetically?

The labels of the columns usually goes from A to AMJ.

However, the columns can also be given numerical labels.

Select Tools ▸ Options ▸ LibreOffice Calc ▸ Formula from the menu, select "Excel R1C1" on the right side of "Formula Options | Formula Syntax" and click OK.