View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default 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...?