R
rsmith844
How do I number cells vertically in succession?
Example:
1
2
3
Thank you.
Example:
1
2
3
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How do I number cells vertically in succession? Example: (1 2 3)
M
Max
One way ..
Enter the 1st number in the starting cell, eg enter in A2: 1. Then
right-click on the fill handle of A2, drag it down as far as required. When
you release, choose "Fill Series" from the pop up menu.
Enter the 1st number in the starting cell, eg enter in A2: 1. Then
right-click on the fill handle of A2, drag it down as far as required. When
you release, choose "Fill Series" from the pop up menu.
P
Peo Sjoblom
There are many way, put 1 in a cell, copy it down using the right button and
when you release the button select fill series. You can also us
edit>fill>series, you can put 1 in the first cell and 2 in the second, grab
both cells and copy down. You can put 1 in a cell, hold down ctrl and copy
down
when you release the button select fill series. You can also us
edit>fill>series, you can put 1 in the first cell and 2 in the second, grab
both cells and copy down. You can put 1 in a cell, hold down ctrl and copy
down
P
Pete_UK
Another way - put the formula:
=ROW(A1)
in your first cell and copy down.
Hope this helps.
Pete
=ROW(A1)
in your first cell and copy down.
Hope this helps.
Pete
S
Sloth
to add another method to the mix...
1. Enter the first few cells (1,2,3)
2. Highlight the cells you filled.
3. Left Click and Drag the "square" at the bottom right of the selection as
far down as you need.
1. Enter the first few cells (1,2,3)
2. Highlight the cells you filled.
3. Left Click and Drag the "square" at the bottom right of the selection as
far down as you need.