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

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Revision as of 13:15, 4 November 2008 by Ufi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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


  1. Enter the formula =row() into cell where the row numbering will start
  2. 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.


Personal tools