Numbering Rows

[shaunbuk]

I have a file containing data which is about 6000 rows deep by 15 columns

There is a column which has a number in each row which starts at 1 and going down to 100

I want to continue this down to 6000 and I know I can put the little cross at the bottom side and drag it down if I like

My question is does anyone know of a faster way to do this like a keystroke shortcut

[Chris 53]

double click on the bottom right of the cell.
Providing the column to the left of the selected cell is populated.

[Fotis1991]

A small macro should do this

Please Login or Register  to view this content.

[shaunbuk]

love this forum

thanks guys

[shaunbuk]

one more question

what should I do if the cell to the left is not populated?

[Chris 53]

Can you find a column that is always populated and put your row counter to the right of that column.

Actually left or right doesn't matter so long as it is next to a populated column.

[shaunbuk]

good point

[Fotis1991]

Suggested macro is not depanted from any other column.

[shaunbuk]

Suggested macro is not depanted from any other column.

Sorry I don't understand this please explain

[shaunbuk]

understand now

dependent?

[Fotis1991]

!!!!!!!!!!!!!Yes