You're welcome, Tim, glad to be of help!
All the best,
Cearbhall
T: +353 (0)1 2864623 m: 08333 23487 E: cearbhall.omeadhra@xxxxxxx
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Culhane
Sent: 02 June 2010 08:55
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Inserting a sequence of numbers in an Excel
column
Hi Cearbhall
Many thanks for this, this did the trick.
Tim
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Cearbhall O'Meadhra
Sent: 01 June 2010 18:01
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Inserting a sequence of numbers in an Excel
column
Tim,
In your description of the column labels you are actually specifying one
row
of fields rather than one column. You then say that you want to fill down
one column. Which did you want to do?
Actually, you can place the series in either a column or a row.
The Row procedure:
If you wanted to place the numbers in row 2 starting in field B2 because
you
have headings in column A and row 1, You would do the following:
Type a 1 in B2. The cursor is now in b2 so hold down the shift key and
arrow
right until you have completed the number of horizontal cells that you
need.
Let's say you go as far as g2 in this example. You now follow the steps
below to fill in the series. The numbers will grow from 1 to 6 starting in
b2 and incrementing up to 6 in g2.
The Column procedure:
To place the series in one column, for example, column B and starting with
b2 to avoid row and column headings. Type the number 1 in field B2. Hold
the
shift key and arrow down the column until you have highlighted all the
rows
you want. In this example of six fields that would take you down to b7.
Next
you follow the series procedure set out below:
The "Fill Series" Function:
When the row or column fields have been highlighted with the value 1 in
the
first field, use the fill series function in Excel. To do this: 1. press
alt-e for the edit menu 2. press I for the "Fill" menu 3. Press "S" for
the
series dialog 4. Check that the step value is 1 (this is the default) and
ignore all the other fields in this dialog. 5. Arrow down to OK 6. Bingo!
You now have the series you wanted.
Using shift and the arrow keys is fine for short ranges of up to ten
fields
but is very hard to control for large ranges. To highlight a long series
of
fields I would recommend that you use the extended selection function
which
is carried out by using f8 and F5. If you need help with the highlighting
just let me know and I will explain how to do that.
All the best,
Cearbhall
T: +353 (0)1 2864623 m: 08333 23487 E: cearbhall.omeadhra@xxxxxxx
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Culhane
Sent: 01 June 2010 16:39
To: vicsireland@xxxxxxxxxxxxx
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
====================
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
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5166 (20100602) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com