Frequently asked questions - Calc

    From The Document Foundation Wiki
    < Faq‎ | Calc
    This page is a translated version of the page Faq/Calc/148 and the translation is 0% complete.


    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.