View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default how do I quickly insert numbers 1 to 100 in a column in Excel?

1 in a1
2 in a2
grab BOTH cells, drag down

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I have a list of itmes that need to be numbered to the right side of the
list. I do not wish to manually enter each number (1 to 100). Is there
way
I can enter the number 1, then pull the cursor down the column until the
cells become populated with the rest of the numbers in sequence? I