I have a sheet which contains the marks of students. row 1 contains the column headings. from A2:G32 i have data(marks and grades). I want to copy the total of marks which lies in G2:G32.I tried the following.
i select the G2 cell. then i pressed control +the down arrow to go to the last cell of the col.then i pressed control +shift+up arrow to go to the top with selection. Now i got the cells G32 :G1 selected. I clicked on the G1 to desselect it. then i clicked to copy. it gives error saying that it cannot be done on multiple selection. i want to select only the data cells not to include the column heading.how can i select the contents G2:G32 without adopting the method of selecting G2 and drag the mouse? how can i do this? thanks.

Hi,

Am Tue, 19 Mar 2013 15:27:15 +0000 schrieb sumesh56:

I have a sheet which contains the marks of students. row 1 contains the
column headings. from A2:G32 i have data(marks and grades). I want to
copy the total of marks which lies in G2:G32.I tried the following.
i select the G2 cell. then i pressed control +the down arrow to go to
the last cell of the col.then i pressed control +shift+up arrow to go to
the top with selection. Now i got the cells G32 :G1 selected. I clicked
on the G1 to desselect it. then i clicked to copy. it gives error saying
that it cannot be done on multiple selection. i want to select only the
data cells not to include the column heading.how can i select the
contents G2:G32 without adopting the method of selecting G2 and drag the
mouse? how can i do this? thanks.

select G2 and press CTRL+Shift+down arrow to select G2:G32


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

When you select G1 you're not deselecting it but reselecting it, so effectively it's selected twice, which is why you get the error message.

Select cell G2 then press Ctrl + Shift and then the down arrow. That will select the cells you need.

thanks for the guidance. it works nicely. have a nice day.