Hi

Everyone is familiar with the excel auto-fill function. But lets say if you have a column or row that included thousands of cells, then in such case, even 'click and drag' would take you very long to complete the filling.

Is there any quicker way to complete the filling in this case?

Also, I tried using auto-fill to fill in the dates in a year and noticed that it doesn't switch from 31-01 to 01-02 but instead it keeps going to 32-01, 33-01 etc., that isn't what I want. How to fix this problem? I already selected date 'dd-mm' in the cell format option.

thx!