(incubating) | The Free and Open Productivity Suite

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 OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. 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.