6/26/2013

Numbered list in Excel - How to make?

How to do in Excel? numbered list 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)

How to do in Excel? numbered list
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.

How to do in Excel? numbered list
Excel 2010 Screen


Video tutorial:


No comments:

Popular tutorials