ExcelBanter - Numbering Rows

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

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

- - Numbering Rows (https://www.excelbanter.com/excel-discussion-misc-queries/133047-numbering-rows.html)

DaleH

Numbering Rows

I'd like to select a range of rows and have an advancing number sequence
inserted in a column such that the first row is numbered "1", the second
row "2", etc.

Toppers

Numbering Rows

Put 1 in first cell, select this cell,hold Ctrl and copy down.

"DaleH" wrote:

I'd like to select a range of rows and have an advancing number sequence
inserted in a column such that the first row is numbered "1", the second
row "2", etc.

All times are GMT +1. The time now is 01:27 AM.