How to create a numbered list in Excel? How can you generate a list of numbers in Excel ? |

- Mark in the Excel spreadsheet cell A1, and type 1, then cell A2 and type 2,
- Select area A1: A2,
- Move your mouse to the lower right corner of the selected field - square (fill handle)

Excel 2010 Screen |

- Click in the box left mouse button and drag vertically down to cell A10,
- Excel automatically enters the numbers in the selected area when the mouse button is released - will increase the value in the next cell on the difference between the numbers in cells A2-A1, etc.

Excel 2010 Screen |

Video tutorial:

## No comments:

Post a Comment