Re: Selecting multiple rows or columns in Excel

  • From: Ann Byrne <annakb@xxxxxxxxxxxxx>
  • To: jfw@xxxxxxxxxxxxx
  • Date: Sat, 30 Jan 2010 19:05:57 -0600

The easiest way is with 'go to'. Use either control-g or f5 for go to, then list what you want selected. Join contiguous fields with a colon, and non-contiguous fields with comma.

So cells a1 through e15 would be goto a1:e15. A1 and e15 would be go to a1,e15. To select rows 1 through 3, go to r1:r3.

JFW related links:
JFW homepage:
Scripting mailing list:
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //
Alternative archives located at:

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

Other related posts: