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