|
| Type the data for the first few cells in the series you want to fill. For example, type Region 1, Region 2, and Region 3 into cells B3, C3, and D3, respectively. |
| Select cells B3, C3, and D3 and move the mouse pointer over the lower-right corner of the range until the pointer turns into a thin, black plus. |
| Pressing and holding down the mouse button, drag horizontally or vertically until all the cells you want to fill are selected. |
| Release the mouse button when you have filled the correct number of series data. |
INTRODUCTION If you have ever typed each and every cell of a series of data into a worksheet (for example, Monday, Tuesday, Wednesday, and so on), the information in this task will save you a lot of time. In a couple quick steps, Excel completes all the time-consuming, repetitive data entry work for you. Be sure to check Excel's work. |
TIP Using Auto Fill Options Use the Auto Fill Options drop-down list to copy the series cells (Copy Cells); fill the series as is, with formatting (Fill Series); fill only the series formatting (Fill Formatting Only); or fill the series without the formatting (Fill Without Formatting). |
TIP Using Intuitive Series Excel automatically fills and repeats common series, such as days of the week, month names, and so on. To experiment, type January into a cell, and then click and drag to select the number of cells you want to fill. |
|