number

How to Automate Row numbers in Excel?

0:00
Toggle fullscreen Fullscreen button

Sharing buttons:

[Music]

[Music]

welcome back fellows Ross and we often

pull in a row numbers as serial numbers

of sequence numbers I'm going to

demonstrate how you can automate them

what do I mean by automate let me share

with you an example so let's say for

example I started creating one sequence

and I added 15 rows to that and 15

different types of data I put in here

now in a case if I want here to remove

some of the rows for example from 5 till

10 and removing you will see the

sequence has removed now I wanted to

keep this row the same automatically

updatable but it's not possible here let

me show you how you can do that and

automate it there's a function for that

in Excel it's called is equal to row

parentheses start and parenthesis closed