29.Auto Sequence

Watch 29.Auto Sequence - PyK_Classics on Dailymotion

Transcript

00:00Many times in Excel, we have to input data in multiple cells vertically.

00:07And we assign serial numbers manually.

00:11If data is huge, assigning serial numbers becomes a hectic job.

00:15And many times we also commit mistakes and assign the wrong serial number.

00:21Here is a trick to avoid this.

00:23We can use the function, sequence, to save our time.

00:26Function is, equal to, sequence, first bracket open, counter, second bracket open.

00:35Select range.

00:39Ensure referencing should be on, means use dollar signs in range.

00:44Second bracket close, again first bracket close, that's it.

00:50Now write data in range, and sequence will automatically come.

00:54Saving of time with no mistakes.