I am a teacher working with EXCEL. I have a list - 3 classes each
alphabetical, but not with final grades. I want a list - 1 list with grade
and then alphabetical listing. I am trying to set this up before the final
grades are list (and subject to change).

The original list has last name (A), first name (B), student ID (C), class 9
thru 12 (D), and I want to put the average in (E).

I am copying CTRL-C and CTRL-V from A-D and moving to G-J and then I tried
in cell K3 the formula =E3 and dragged that down thru the column. When I
sorted G thru K based on J and A and B the K column stayed in the same order
while the other columns sorted. How do I get the K column to 'sort' like
the other (I) columns did?

I tried the idea of putting a '$' on the number part of the formula, but I
know that will not drag down. Instead of =E3, I made it =E$3, and that one
moved but K3 now was still = E3. Is there an easy way to put the dollar sign
on all (the whole column) ?