| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbering a filtered list in Excel 2002
I have a workbook with two worksheets. The first contains my entire
list of data, and the second is filtered to show only data from 2007. I would like the filtered worksheet to be numbered numerically. For example, even though the rows are numbered 1, 2, 11, 14, 61, 70, etc.; I would like column A to be numbered 1, 2, 3, 4, 5, etc. Is this possible? When I use the fill command the column is just filled with a single digit. Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbering rows in a filtered worksheet | Excel Worksheet Functions | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
| how can I rank within a filtered list in Excel? | Excel Discussion (Misc queries) | |||
| Filtered list in Excel 2002 | Excel Discussion (Misc queries) | |||
Threaded Mode
