Wednesday, September 23, 2020

Repeat 1 to 10 in excel column

Sometimes, we may need to repeat a set of values in excel. Manually typing will take more time. Inorder to ease the process, you can follow any one of the following steps.

First type 1 to 10 in each column.

Now in the eleventh column, use the formula where the eleventh cell is equal to first cell.

Now drag it until you need the set of numbers to be repeated.

Tha another classic way of repeating a set of values is, first set you have to manually. Then copy the sets and paste it to get next set. Now copy both sets to get 3 and 4 th set.Now copy 4 sets to get 8 , followed by 16,32,64,128..

Even though it looks time consuming, believe me, it will not take more than 5 minutes,since it copies exponentially.