This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.
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):
- Enter the formula =row(a1) in cell A1.
- 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.