Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.6 released

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 and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.