[vicsireland] Re: Inserting a sequence of numbers in an Excel column

  • From: "Anthony Roche" <anthonyroche@xxxxxxxxxx>
  • To: <vicsireland@xxxxxxxxxxxxx>
  • Date: Wed, 2 Jun 2010 02:58:00 +0100

Good morning.

This is my initial attempt but much overtaken by Cearbhall at 18:01 last night.

Mise le meas,

Antóin

Encl.
     heading 1
    2.00
    3.00
    4.00

    Continue
    to add the
    increment
    1 with the
    formula

    b(n)=b(n-1)+1
    Format the
    column as
    numeric






----- Original Message ----- From: "Tim Culhane" <tim.culhane@xxxxxxxxxxxxxxxx>
To: <vicsireland@xxxxxxxxxxxxx>
Sent: Tuesday, June 01, 2010 4:39 PM
Subject: [vicsireland] Inserting a sequence of numbers in an Excel column


Hi,

I  want to enter a number  like '1'  in   column b1 in my Excel worksheet,
(column A1 contains  a column heading).

I then want to auto fill the rest of the column with numbers, increasing in
sequence so that c1 contains 2, d1 contains 3 etc.

Anybody know how I can do this from the keyboard?

Cheers,

Tim


-------------------------
Tim Culhane,
Critical Path Ireland,
42-47 Lower Mount Street,
Dublin 2.
Direct line: 353-1-2415107
phone: 353-1-2415000

Tim.culhane@xxxxxxxxxxxxxxxx
http://www.criticalpath.net

Critical Path
a global leader in digital communications
------------------------



===========================================================
The vicsireland mailing list

To unsubscribe at any time send a mail to:

vicsireland-request@xxxxxxxxxxxxx

with the word "unsubscribe", without the quotes in the subject of the message.

To contact the moderator send mail to:

tim.j.culhane@xxxxxxxxx

For mor information on the Visually Impaired Computer Society visit:

http://www.vicsireland.org




===========================================================
The vicsireland mailing list

To unsubscribe at any time send a mail to:

vicsireland-request@xxxxxxxxxxxxx

with the word "unsubscribe", without the quotes in the subject of the message.
To contact the moderator send mail to:

tim.j.culhane@xxxxxxxxx

For mor information on the Visually Impaired Computer Society visit:

http://www.vicsireland.org

Other related posts: