Corrosponding excel generated numbers with 1st row numbers
 

Does anyone know if you can move the row numbers down that are generated by
excel. Would like my spreadsheet to have corrosponding numbers.

eg.
Row#
1 Job No
2 1
3 2
4 3

Thanks
Anne

Corrosponding excel generated numbers with 1st row numbers
 

try this formula starting at row 2:
=Row()-1
then just fill it down as far as you need to go. The Row() will always
return current row number, so the -1 will reduce that value by 1. Change -1
to whatever you really need if necessary.

"Anne_Nev" wrote:

Does anyone know if you can move the row numbers down that are generated by
excel. Would like my spreadsheet to have corrosponding numbers.

eg.
Row#
1 Job No
2 1
3 2
4 3

Thanks
Anne