top of page

quickly enter data

Excel Tip: Quickly enter a series of dates, times, weekdays, months, or years using the Autofill feature. For example, you can enter January in a cell, and then fill the cells below or to the right with February, March, etc.


To use Autofill, first select the data which we need to fill down below and then click and drag the pointer, which is located at the bottom right corner, to all subsequent cells. In the example below on the left, the fill handle is highlighted in the red circle. In the middle picture, notice as I drag the fill handle down 2 cells the word March appears. Release the mouse click and the months are filled in.



Recent Posts

See All
bottom of page