follow me on facebook follow me on twitter Instagram

Fill: Months

Fill will save you hours of time. You no longer have to type in the months of the year, or copy the months from another spreadsheet. 

Enter January in the cell you want it to appear. 
Hit enter.
Click on the cell that has January in it as shown below. 

In the bottom right corner of the selected cell [January above] there is a little box.
The little box is called the Fill Handle

Move you mouse over top of the box. The cursor becomes a big  + [plus sign].

Click on the box and drag the mouse to the right as shown above. 
Each month is placed in a cell.  
Let go of the mouse when you get to December

Note: It will keep going to the next year if you continue to drag the mouse. 

Check out other Fill items that will save you more time.

No comments:

Post a Comment