| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I restore header numbers for rows in a worksheet?
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| continue page numbers from previous worksheet | Excel Discussion (Misc queries) | |||
| ADDING NEW NUMBERS TO EXISTING WORKSHEET | New Users to Excel | |||
| Print sequential page numbers on one worksheet printed multiple ti | Excel Worksheet Functions | |||
| changing page numbers in repeated header | Excel Discussion (Misc queries) | |||
| increment/populate numbers by worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
