Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
|
|||
|
|||
Answer: how do i make values increase by 1 while going down a cell
To summarize:
To use the Fill Handle:
To use the Fill Series:
I hope this helps! Let me know if you have any other questions.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
My column cell values are -ve how do I make all cell value +ve, | Excel Worksheet Functions | |||
how to make a formula to increase sales of january by 1.56% need | New Users to Excel | |||
How do I make the X-Axis increase in scale with the quantity? | Charts and Charting in Excel | |||
How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions |