Here are two time-savers you can use to enter data in Excel:
AutoFill enter the months of the year, the days of the week, multiples of 2 or 3, or other data in a series. You type one or more entries, and then extend the series. For extending series drag the cell to following cells.
For writing series as 1, 3, 5, 7 write first 3-4 entries in cells, select those cells and then drag from last cell to complete the series.
AutoComplete If the first few letters you type in a cell match an entry you've already made in that column, Excel will fill in the remaining characters for you. Just press ENTER when you see them added. This works for text or for text with numbers. It does not work for numbers only, for dates, or for times.
760 total views, 1 views today