Autofill option can be implemented in Excel 2007 through mouse by selecting the cells and dragging left or right till the desired cells are filled with the values.
1. Plus sign under the selected column should appear to drag the selection to enable autofill option.
2. If it doesnot appear, Click on Microsoft button on the left-top most of the window. Go to Excel Options.
3. Click Advanced and select “Enable fill handle and cell drag-and-drop” checkbox.
4. Now try to drag the cell till the desired cell. The values will be auto-populated.