Difference between revisions of "Documentation/FAQ/Calc/Formatting/How do I format cells in Calc so that the rows number automatically?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
(New page: {{DISPLAYTITLE: How do I format cells in Calc so that the rows number automatically?}} <section begin=question/> '''How do I format cells in Calc so that the rows number automatically?'''...) |
m |
||
Line 9: | Line 9: | ||
# Extend the cell by dragging the bottom right corner all the way down to the cell you want the numbering to end | # 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.}} | |
− | * If you insert new rows, you will have to copy the formula to the new cells. | + | |
Latest revision as of 14:43, 2 October 2021
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