View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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!