[vicsireland] Re: selecting alternate rows in excel

  • From: "Flor Lynch" <florlync@xxxxxx>
  • To: <vicsireland@xxxxxxxxxxxxx>
  • Date: Wed, 1 Oct 2008 16:37:38 +0100

I did the ECDL before; reading other people's messages (in this case) jogged 
my soft cells soemwhat; reading Microsoft help - using the Help Index 
(usually), or the search field if the former doesn't really help; and 
synthesizing relevant bits and pieces of information (from here and there).

----- Original Message ----- 
From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
To: <vicsireland@xxxxxxxxxxxxx>
Sent: Wednesday, October 01, 2008 4:20 PM
Subject: [vicsireland] Re: selecting alternate rows in excel


Gosh Flor, You are amazing. I wasn't aware this was even possible. Just
how do you store all that knowledge?
-----Original Message-----
>From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Flor Lynch
Sent: Wednesday, October 01, 2008 4:15 PM
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: selecting alternate rows in excel

Right Paul, for your example:  In Excel press ctrl-g; then type into the

edit field: A2:a7,C5:c10     and your two ranges (two areas) will be
highlighted (or selected).  (A comma between the two ranges.)

----- Original Message ----- 
>From: "Paul Halligan" <tigerone@xxxxxxxxxx>
To: <vicsireland@xxxxxxxxxxxxx>
Sent: Wednesday, October 01, 2008 11:47 AM
Subject: [vicsireland] selecting alternate rows in excel


Blankhi folks
in excel i want to select a range of cells, say from a2 to a7 and i also

want to select the range c5 to c10 , in other words without doing
anything
to the b column.
any help on this action?
thanks aforehand
Paul H


===========================================================
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

Other related posts: