2. Excel Tips - Create numbers 1 to 10 easily

Nick's picture

You can easily create a list of numbers by:

Step1:
In cell A1, type: 1

Step2:
In cell A2, type: 2

Step3:
Select the range A1 to A2

Step4:
Click and drag down to A10 the square in the bottom right of your selection

.. you can drag this as far as you want, and it will keep on incrementing the number

Video Training on creating numbers 1 to 10:

Here's an easier

Here's an easier way:

Step1:
In cell A1, type: 1 and do not press Enter

Step2:
With the Ctrl key held down, drag the fill handle down to A10; release the mouse before the Ctrl key