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