![]() | 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