[vicsireland] Re: Inserting a sequence of numbers in an Excel column
- From: "Eamonn X. O'Connor" <EXOConnor@xxxxxxx>
- To: vicsireland@xxxxxxxxxxxxx
- Date: Thu, 3 Jun 2010 09:55:58 +0100
Hi Cearbhall and Tim,
Many thanks for this.
I use an Excel spreadsheet for keeping track of my clock-ins at work, in
case any amendments have to be made.
It will be handy now not having to manually enter the day and date each
day.
Regards,
Eamonn
"Cearbhall
O'Meadhra"
<cearbhall.omeadh To
ra@xxxxxxx> <vicsireland@xxxxxxxxxxxxx>
Sent by: cc
vicsireland-bounc
e@xxxxxxxxxxxxx Subject
[vicsireland] Re: Inserting a
sequence of numbers in an Excel
02/06/2010 16:22 column
Please respond to
vicsireland@freel
ists.org
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
**********************************************************************************
Is le haghaidh an duine nó an eintitis ar a bhfuil sí dírithe, agus le haghaidh
an duine nó an eintitis sin amháin, a bheartaítear an fhaisnéis a tarchuireadh
agus féadfaidh sé go bhfuil ábhar faoi rún agus/nó faoi phribhléid inti.
Toirmisctear aon athbhreithniú, atarchur nó leathadh a dhéanamh ar an
bhfaisnéis seo, aon úsáid eile a bhaint aisti nó aon ghníomh a dhéanamh ar a
hiontaoibh, ag daoine nó ag eintitis seachas an faighteoir beartaithe. Má fuair
tú é seo trí dhearmad, téigh i dteagmháil leis an seoltóir, le do thoil, agus
scrios an t-ábhar as aon ríomhaire. Is é beartas na Roinne Dlí agus Cirt agus
Athchóirithe Dlí na nOifígí agus na nGníomhaireachtaí a úsáideann seirbhísí TF
na Roinne, seoladh ábhair cholúil a dhícheadú.
Más rud é go measann tú gur ábhar colúil atá san ábhar atá sa teachtaireacht
seo is ceart duit dul i dteagmháil leis an seoltóir láithreach agus le
mailminder[ag]justice.ie chomh maith.
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please contact
the sender and delete the material from any computer. It is the policy of the
Department of Justice and Law Reform and the Agencies and Offices using its IT
services to disallow the sending of offensive material.
Should you consider that the material contained in this message is offensive
you should contact the sender immediately and also mailminder[at]justice.ie.
**********************************************************************************
==========================================================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: