Frequently asked questions - Calc

TDF LibreOffice Document Liberation Project Blogs communautaires Weblate Nextcloud Redmine Ask LibreOffice Donner

• Accueil
• Development
• Design
• QA
• Évènements
• Documentation
• Website
• Localisation
• Accessibility
• Marketing
• Diversity
• Aide

• Documentation
• Publications officielles
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ
• Tutoriels généraux
• Writer
• Calc
• Impress
• Draw
• Math
• Base

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.