Fill up numbers 1 to 100,000, from cell A1 to A100,000

Hello!

Often I need to fill up series as in the name of the title. One way is to click on the corner of the cell and drag it all the way down, but is there a more efficient way?

Thank you

Neori

It works perfectly well. Thank you very much.

One more question!

I often download data from our IT system and dates are in "General" format. After that, I normally select the dates and change the format to "Dates". However, when trying to use Pivot Table, I can't group dates into months.

In case I double click every cell for every date, I can use Pivot table and group by month, year, etc. Do you know what might be a solution, instead of clicking each date every? As the list is really long- 100,000++, I use Autohotkeys to actually double-click every cell and although automatic, it takes hours to complete. Do you know of a more efficient way?

Thank you for your help with series. It will save me quite some time!

Neori