View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How to get these cells into 1 column

As your numbers increase by 25 each time, you could enter 0 in the
first cell and highlight this down to your bottom cell, then use Edit |
Fill | Series and specify linear with an increment of 25.

Hope this helps.

Pete

Chris wrote:
Okay that post was butchered up. Here's what it should look like.

0 25 50 75 100
125 150 175 200 225
250 275 300 325 350

Here's what I want:
0
25
50
75
100
...etc

"Chris" wrote:

Any ideas how to get this format of numbers into 1 column?

0 25 50 75 100 I would like this: 0
125 150 175 200 225
25
300 325 350 375 400
50

75.....etc