BlankHi Paul. You need to get the cursor into the edit box and type the co-ordinates e.g. a1:a7,c1:c7 Press enter and the two sets of co-ordinates should then be highlighted. Damien. ----- Original Message ----- From: Paul Halligan To: vicsireland@xxxxxxxxxxxxx Sent: Wednesday, October 01, 2008 11:47 AM Subject: [vicsireland] selecting alternate rows in excel hi 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 -- I am using the free version of SPAMfighter for home users. SPAMfighter has removed 1665 spam emails to date. Paying users do not have this message in their emails. Get the free SPAMfighter here: http://www.spamfighter.com/len