# Auto Number

#### amna77

##### Active Member
Hi, In my column A, I have nubers, like 1 through 300. So my 300 rows are filled with data. Now if I cut the row number 50, then I want numbers to be in right order, I don't want 49, 51. Instead of that I want 49,50,51, etc. you know what I mean?
Any one help me with that.

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

##### MrExcel MVP
set up the numbering using formulas rather than hard coded values:

=row()

or, if the data starts in row2 ('cos of column headings in the first row):

=row()-1

#### amna77

##### Active Member
Thank you very much for help

#### apurk45

##### Board Regular
Hi

One time I used this:
In first Row (in my case cell A7) I had:

=IF(B7="","",1)

in the Row below I had:

=IF(B8="","",MAX(A\$7:A7)+1)

Then:

=IF(B9="","",MAX(A\$7:A8)+1)
and so on

Replies
1
Views
154
Replies
4
Views
82
Replies
1
Views
176
Replies
19
Views
699
Replies
8
Views
115

1,148,339
Messages
5,746,177
Members
423,998
Latest member
eakenila

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back