[SOLVED] How to correct this missing numbering series in Excel?

[Ganesh Ujwal123]

I deleted a 45th row, but numbering system gone wrong like this:

Now I need correct from 45th row. please help me.

Google only shows results of where to find missing numbers

but never shows me results of how to correct those missing numbers.

 

[rgd1101]

the image make no sense.
if you need the row 58 with #46 to #45, change it

 

[USAFRet]

I deleted a 45th row, but numbering system gone wrong like this:



but never shows me results of how to correct those missing numbers.

Change row 58 to 45.
Change row 59 to 46.
Select the handle and drag down as needed.

 

[Ganesh Ujwal123]

Change row 58 to 45.
Change row 59 to 46.
Select the handle and drag down as needed.

I done exactly as you said, this new error pops up:

 

[USAFRet]

I done exactly as you said, this new error pops up:

Not 'merge'....autofill.

 

[Alabalcho]

On this column, select cells with numbers "43" and "44". On cell 44, grab lower right corner, and drag it down till the end of the column.

A better approach is to use formulaes. Put "1" in A1, and "=A1+1" in A2, then replicate the formula from A2 down.