To add the first six months of the year, drag the fill handle until the ScreenTip says June and then release the mouse button to fill the list.
Pretend that you're typing the first six months of the year for the umpteenth time. Only this time you'll do it the easy way.
- Type "January" so that Excel knows what you want.
- Select the January cell, and then position the mouse pointer over the lower-right corner of the cell until the black cross (+) appears.
- Drag the fill handle over the range you want to fill. As you drag, the ScreenTip tells you what will be filled in.
- Release the mouse button to fill the series in.
- For some lists you need to type two entries to establish a pattern. For example, to fill in a series of numbers such as 3, 6, 9, type two numbers, select both cells, and then drag the fill handle.
- You can also drag up or to the left as well as drag down or to the right.
- Ever need to type the same word many times, such as Complete in 10 consecutive rows? Just type the word once, and then drag the fill handle down rows or across columns to enter the same text without typing.