Putting row numbers in cells

A

analyst41

I want to set up a column in which the entry in each row is simply the
row number, possibly with a constant offset.

Thank for any help.
 
N

Niek Otten

=ROW()

or

=ROW()+16

16 could be anything, of course

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to set up a column in which the entry in each row is simply the
| row number, possibly with a constant offset.
|
| Thank for any help.
|
 
Top