# How do I format cells in Calc so that the rows number automatically?

From Apache OpenOffice Wiki

< Documentation | FAQ | Calc | Formatting

**How do I format cells in Calc so that the rows number automatically?**

- Enter the formula
**=row()**into cell where the row numbering will start - Extend the cell by dragging the bottom right corner all the way down to the cell you want the numbering to end

**Note:**

- If you insert new rows, you will have to copy the formula to the new cells.