Instead of entering all your data manually, you can use the AutoFill feature to fill cells with data that follows a pattern. Note that AutoFill works with numeric data, but not text.
1. Select one or more cells you want to use as a basis for filling additional cells.
2. Drag a corner handle vertically or horizontally.
3. The selected cells are now filled automatically.