if your data starts on row 2, for instance, use

=ROW()-1

if it starts on row 5, use

=ROW()-4

"Liz" wrote:

I'm making a large text database that prints onto 2 pages, and I need to
number each row in order to make it easier to locate items on both pages.
What kind of function (and exactly how do you do it?) do I need to make a
counter that automatically changes the numbers when I update information/add
cells?
Example:
1. Amber Grove Apts.
2. American River Apts... etc.

If I need to add something above #1, I want to number to change accordingly.
Help! Thanks, Liz