How do I restore header numbers for rows in a worksheet?

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.

Never mind. I found that I had set the formatting so that the Header numbers
for those rows were Justified to the top instead of the bottom.

"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.

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 <[email protected]>
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.