Thread
:
how do I quickly insert numbers 1 to 100 in a column in Excel?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett