Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.10

This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

How do I format cells in OpenOffice.org Spreadsheet so that the rows number automatically?

One method (this example assumes that you wish to put your row numbers in column A):

  1. Enter the formula =row(a1) in cell A1.
  2. Extend the cell by dragging the bottom right corner all the way down column A.

Note: If you add or insert new rows, you will have to copy the formula to the new cells.

Documentation / User FAQ / Calc / Previous-Next

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.