Autofill let you create lists easily in Excel.
- In a new worksheet, type as follows.
- Place the pointer in cell A1.
- Move the mouse to the bottom right of cell A1, till it changes to a thin +.
- Drag until cell A10.
- Do the same for other columns
Autofill feature can be used to do planning of rosters, time sheets etc.
View EasyElearn video on Microsoft Excel - AutoFill