ExcelBanter

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/132909-numbering-rows.html)

DaleH

Numbering Rows
 
I'd like to be able to select a range of records and insert a number
sequence (1,2,3...) in a column so that the first row in the sequence is
1, the second is 2, third is 3, etc.

Thanks,
Dale Hoffman

JE McGimpsey

Numbering Rows
 
One way:

Enter 1 in the first cell. Choose Edit/Fill/Series... Click OK

In article ,
DaleH wrote:

I'd like to be able to select a range of records and insert a number
sequence (1,2,3...) in a column so that the first row in the sequence is
1, the second is 2, third is 3, etc.

Thanks,
Dale Hoffman



All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com