PC Review


Reply
Thread Tools Rate Thread

Create a numerical sequence in a column: From 1 to ....

 
 
=?Utf-8?B?RGVwZWNoZXo=?=
Guest
Posts: n/a
 
      18th Jul 2006
I want to automatically generate a sequence of numbers from 1 to....X without
typing them all. How?
 
Reply With Quote
 
 
 
 
Bondi
Guest
Posts: n/a
 
      18th Jul 2006

Depechez wrote:
> I want to automatically generate a sequence of numbers from 1 to....X without
> typing them all. How?


Hi Depechez,

You could type in 1 in A1 and 2 in A2.
Then highlight them and pull the autofill handle (The little black
square in the buttom right cornor of your highligted selection) to the
row you want to.

Regards,
Bondi

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      18th Jul 2006
In A1 enter 1

In A2 enter 2

Select both cells and drag/copy down column A as far as you wish.

OR

Enter 1 in A1

In name box enter A1:A12300 and ENTER

Edit>Fill>Series>OK


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 08:59:02 -0700, Depechez
<(E-Mail Removed)> wrote:

>I want to automatically generate a sequence of numbers from 1 to....X without
>typing them all. How?


 
Reply With Quote
 
=?Utf-8?B?Um9uIENvZGVycmU=?=
Guest
Posts: n/a
 
      18th Jul 2006
Try this:

Put the number 1 in the first cell and leave that cell selected

Then
From the Excel main menu:
<edit><fill><series>
Series in: (check Rows or Columns)
Stop Value: (enter the last number of the series)
Click the [OK] button


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Depechez" wrote:

> I want to automatically generate a sequence of numbers from 1 to....X without
> typing them all. How?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numerical in sequence Maria (MAC) Microsoft Access Database Table Design 8 20th May 2008 01:55 PM
numerical in sequence Maria (MAC) Microsoft Access 3 15th May 2008 10:59 PM
CHANGES - Recurring Monthly Numerical Sequence kdunn44107 Microsoft Excel Worksheet Functions 1 13th Oct 2004 02:48 PM
Numerical sequence Kassie Alcorn Microsoft Excel Discussion 3 16th Jun 2004 04:21 AM
Counting a Numerical Sequence Rick D Microsoft Excel Worksheet Functions 6 3rd Dec 2003 06:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:13 AM.