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!