Quote:
Originally Posted by officeboy09
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!
|
Apart from Pecoflyers suggestions;
If the cells to the left are filled ctrl-click the fill handle to fill to the bottom. Doesn't work as well to the right. (Note if you have some data in the column you are filling below where you start it only fills to the last blank cell)
b) Set a custom fill series, haven't tried dd/mm but should work, see
http://www.dummies.com/how-to/conten...pageNum-8.html