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

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!

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

To summarize:

To use the Fill Handle:

1. Enter the first number in the cell where you want the series to start.
2. Click and hold the fill handle with your mouse.
3. Drag the fill handle down to the last cell where you want the series to end.
4. Release the mouse button.

To use the Fill Series:

1. Enter the first two numbers in the cells where you want the series to start.
2. Select both cells.
3. Click on the "Fill" button in the "Editing" group on the "Home" tab.
4. Click on "Series" in the drop-down menu.
5. In the "Series" dialog box, select "Columns" in the "Series in" section.
6. In the "Type" section, select "Linear".
7. In the "Step value" section, enter "1".
8. Click "OK".

I hope this helps! Let me know if you have any other questions.

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

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

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"michelle" wrote in message
...
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!

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

Enter a number in A1.

Right-click and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Wed, 14 Nov 2007 12:33:19 -0800, michelle
wrote:

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!