How to quickly fill in numbers from 1-500 and then repeat, so as not to stretch it manually ??

Question

excel

There are columns of 100 thousand rows how to quickly fill the column to the end with numbers from 1-500 and then repeat, so as not to stretch it manually ?? I suffer with this.

Answer 1

As an option
, write down 1 in the first cell
- Put the cursor in the second cell
- Move the slider down the sheet and hold down the Shift key and click on the last cell of the column. The working range will
be highlighted - Place the cursor in the formula bar and enter the formula =ЕСЛИ(R[-1]<500;R[-1]C+1;1)if you have numbers in the column names, or =ЕСЛИ(A1<500;A1+1;1)if there are letters in the column names (attention, in the formula in this case, correct the letter of the column). Press Ctrl+Enter
- The working range will be filled with the formula. Without removing the selection, copy (Ctrl + C) and paste only the values ​​\u200b\u200b(Ctrl + Alt + V)