It’s a favorite feature of every Excel user. Simply select a series of cells with incremental values and drag the cell corner down to complete the rest of the series. Most common usage scenario is when people try to complete the serial # column.
This feature is turned on by default but for some reason disappeared from my system. It took few days for me to figure out where the toggle button is. Let me share it for the benefit of my blog readers.
In Excel 2010
- Click on File on top left corner
- Click Options again on the left hand side (above the Exit ) button
- It brings up the Excel Options dialog box and select the Advanced section on left.
- The relevant settings are highlighted in the image below