| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Change row numbers
When I populate rows of cells with data in an Excel work sheet, the rows are
numbered sequentially beginning with 1. If I delete some of the rows, the row numbers are deleted and the numbering of the remaining rows is no longer sequential. How do I re-number the remaining rows sequentially? |
|
#2
|
|||
|
|||
|
Rows are ALWAYS numbered 1 to 65536 whether you delete some or insert some.
So the only thing I can imagine you're seeing is that you have some rows hidden. Select all the cells & use Format/Rows/Unhide Bob Umlas Excel MVP "Shredder" wrote: When I populate rows of cells with data in an Excel work sheet, the rows are numbered sequentially beginning with 1. If I delete some of the rows, the row numbers are deleted and the numbering of the remaining rows is no longer sequential. How do I re-number the remaining rows sequentially? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Change Axes Scale Dynamically | Charts and Charting in Excel | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
| Time Stamp without change | Excel Discussion (Misc queries) | |||
| Time Stamp-With Change | Excel Discussion (Misc queries) | |||
Hybrid Mode
