how do i make values increase by 1 while going down a cell

M

michelle

I enter in numbers in a column and i want to drag the box down and have the
number increase by one from the previous number in each cell. HELP!
 
B

Bernard Liengme

Enter the first in A1 (23 for example) and the second (24) in A2
Select A1 and A2 and pull the fill-handle (solid square in lower right of
selected cell) down the column

Or enter the first number; select the range to fill; use Edit | Fill ->
Series
best wishes
 
G

Gord Dibben

Enter a number in A1.

Right-click and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Paragraph numbering in Word 1
Drop down list control value in vba 2
How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Copy addition formula of non-consecutive horizontal cells 2
Finding the proper style field and the numbered paragraph value within the style 0
Copying a formula with an increase of more than 1 8

Top