Browse » Home
Tuesday, December 18, 2012
How to Fill a Series in Excel 2007
1. Type out a series of numbers in the cells you want the start your series. For example, type '1' in cell A1, '2' in cell A2, then '3' in cell A3.
2. Click on the first number in your series, then press 'Shift' and using the arrow buttons highlight the remainder of the series you typed. In the example, highlight cells A1 through A3
3. Click and hold the click in the lower, right-hand corner of the highlighted cells, then move the mouse down to highlight the empty cells where you want to continue your series. In the example, click and hold on the bottom right of cell A3, then drag the mouse down to cell A6. Microsoft Excel will fill cell A4 in with '4,' A5 with '5' and A6 with '6.'