ExcelBanter - How do I # my rows in ascending order.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I # my rows in ascending order. (https://www.excelbanter.com/excel-worksheet-functions/72146-how-do-i-my-rows-ascending-order.html)

burgos

How do I # my rows in ascending order.

My first row is numbered 28 on the side bar. How do change that to number
one, two, three etc...?

Elkar

How do I # my rows in ascending order.

I'd use Column A for your row numbers. Or insert a new column if A is
already used. Then use this formula in A28:

=Row()-27

Copy down as needed.

HTH,
Elkar

"burgos" wrote:

My first row is numbered 28 on the side bar. How do change that to number
one, two, three etc...?

All times are GMT +1. The time now is 05:42 AM.