View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I restore header numbers for rows in a worksheet?

Have you hidden some rows?

Do you have Autofilter enabled?


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 12:29:01 -0700, JLGWhiz
wrote:

Only three row header numbers of an Excel worksheet are blank. When I tried
to fill them by using the insert method, it just moved the blank spaces down
the sheet. I know there is a way to restore the numbers but I cannot find it
in the online help and I am not sure how i lost them in the first place.