Using AutoComplete
	Two common requirements when entering data in MS Excel are the repetition of a particular number across a range of cells and the creation of a series of numbers, dates, etc.
Creating a Series
	There are many different types of series. Some examples of these are shown in the following table.
	The technique used for creating a series is called AutoComplete. 1. At the start of the range of cells enter two examples of the series into two contiguous cells; in this example January and February.
	2. Left-click mouse button and select the two cells, then drag the ‘handle’ (square, black box in the lower right-hand corner of the second cell you highlighted) across the required range. When you release the left mouse button the series will be displayed in the cells that you have dragged across. As you drag across the required range a pop-up box indicates the last value in the range; in this example March is shown to the right of the third cell after dragging the ‘handle’.
Repeating the Same Number Across a Range of Cells
	1. At the start of the range of cells enter the number you wish to repeat. 2. Left-click to select the cell and drag the handle which appears in the bottom right hand corner across the required range. 3. Release the left mouse button and the contents of the cell will be repeated in the cells that you have dragged across.
AutoFormat:
	Excel has built-in formats that you can apply to your data using the AutoFormat command. Follow these directions to use AutoFormat: 1. Select the data you wish to format 2. Choose AutoFormat from the Format menu. The following dialogue box will be presented:
	3. Choose one of the built-in formats from the left-side column with the heading Table format. It shows a list of all built-in formats for easy reference. In the center is a Sample table which will display the chosen format. 4. Left-click on OK to apply the format to the selected range of cells. You may also want to select options for the chosen table. 1. While in the AutoFormat menu, click the Options>> button to see a list of format options. Included are the following: Number, Border, Font, Patterns, Alignment, Width/Height. 2. Left-click the box next to the option to select/deselect it.