View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How to add consequetive numbers in column

I'd do this:

Edit|Goto|type A1:A50|hit enter
type:
=row()
and hit ctrl-enter (which will fill all those cells with that formula)

Then (with A1:A50 still selected):
edit|copy
edit|paste special|values



Chadi wrote:

How do I add an X amount of consequetive numbers in a particular column,
starting from say for example Column1 / Row 1, Number 1 downt to Column 1 /
Row 50, Number 50?

--
www.talkjesus.com


--

Dave Peterson