ExcelBanter - Putting row numbers in cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Putting row numbers in cells (https://www.excelbanter.com/excel-discussion-misc-queries/117526-putting-row-numbers-cells.html)

[email protected]

Putting row numbers in cells

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.

Niek Otten

Putting row numbers in cells

=ROW()

or

=ROW()+16

16 could be anything, of course

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
|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.
|

Ron de Bruin

Putting row numbers in cells

You can use a formula

=ROW()

--
Regards Ron de Bruin
http://www.rondebruin.nl

wrote in message ups.com...
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.

[email protected]

Putting row numbers in cells

Niek Otten wrote:
=ROW()

or

=ROW()+16

16 could be anything, of course

thank you both.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
|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.
|

All times are GMT +1. The time now is 02:32 AM.