How do i set up a concecutive numbers in Microsoft excel sheet?

's Computer Specifications

's Computer Specifications

Put your starting number in A1 (eg 1). Put this formula in A2:

=A1+1

Then copy that formula down column A for as many rows as you need.

Hope this helps.

Pete

On Apr 21, 11:16*pm, Gisela Pacheco <Gisela
Pach...@discussions.microsoft.com> wrote:
>

's Computer Specifications

Hi Gisela,

I normally do it the way Pete has suggested too, but you can also reference
the ROW formula.

E.g. If you want A1 to equal 1 then formula is simply =Row().

But if you want A1 to equal 100 then formula is =Row()+99.

You can drag these formulas down for as many rows a you require.

Cheers,

Matt

"Pete_UK" wrote:

> Put your starting number in A1 (eg 1). Put this formula in A2:
>
> =A1+1
>
> Then copy that formula down column A for as many rows as you need.
>
> Hope this helps.
>
> Pete
>
> On Apr 21, 11:16 pm, Gisela Pacheco <Gisela
> Pach...@discussions.microsoft.com> wrote:
> >
>
> .
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to ID numbers in Excel sheet that add up to specific sum?	Kassira	Microsoft Excel Worksheet Functions	1	25th Jul 2008 03:26 AM
hOW TO ELIMINATE COL. ABC ROW AND ROW NUMBERS IN EXCEL SHEET	=?Utf-8?B?RGlhbmVNTHluY2g=?=	Microsoft Excel Setup	3	20th Apr 2006 04:47 PM
Concecutive page numbers across differnet reports?	=?Utf-8?B?TWFyayBIYWxleQ==?=	Microsoft Access Reports	3	15th Feb 2006 03:48 PM
How do I bin numbers by a date in an Excel sheet	=?Utf-8?B?TmF0YXJhamFuIEdhbmVzYW4=?=	Microsoft Excel Worksheet Functions	7	22nd Jun 2005 11:10 AM
Can I randomize whole numbers in my excel sheet?	=?Utf-8?B?QW5nZUNQNw==?=	Microsoft Excel Worksheet Functions	4	14th Jun 2005 08:05 PM