2. Excel Tips - Create numbers 1 to 10 easily
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:
»
- Nick's blog
- Login or register to post comments
- 57068 reads
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