Excel knows to fill down\/right when you are working with dates, days, months, years and even quarters.\u00a0 That is very helpful and quick.<\/p>\n
When you fill any values, an Auto Fill Options<\/em> box pops up which you can click and select the different options available.<\/p>\n If you are filling dates, then you have the option to auto fill by Weekdays, Months and Years.\u00a0 How cool is that!<\/p>\n Another trick is if you want to fill down an incremental number, say from 1 to 2,3,4,5,6…..<\/p>\n To do this you need to enter the number 1 in a cell, hold down the CTRL key and then fill down that cell which will increment the numbers.<\/p>\n Try these tricks for yourself by downloading and practicing below:
\n