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