To copy cells (like the student names) highlight them.
	Note that the first name, Allen, is not shaded like the rest. It is still selected since it is inside the bold outline.
There are many ways to copy	Use the toolbar Use the Edit menu Right-click the cells Use Ctrl +C on the keyboard
Click in the first cell where you want to paste your list. and choose to paste in one of the ways listed.	Use the toolbar Use the Edit menu Right-click the cells Use Ctrl +V on the keyboard
To get rid of the ants, running around the copied information, click the escape key (ESC) or the spacebar or any other letter keys on the keyboard.
Freeze panes To keep some of the information on your spreadsheet in view at all times, freeze either columns or rows or both Freeze columns To freeze the last name, first name and quarter grade columns, click the letter D on the column headings (that is the next column to the right of the information you wish to freeze.
	Then click the Window menu and choose Freeze panes
To Unfreeze panes, click in the same column indicated above, choose Window, Unfreeze panes. Freezing rows is done the same way. To freeze a row and column, click in the cell just to the right and below the information you want to freeze.
The example to the right would freeze the first 3 rows and columns A thru C.
Conditional Formatting The Quarter average column will turn red if the student's grade falls below a C. It was done with conditional formatting. Select the cells you want to apply the formatting to. Click Format, Conditional Formatting. In the next window, type in the parameters. For mine it was numbers between 1 and 69.4. Then click the Format button.

	In the next window, I choose Color and choose a red color. You will click OK twice to complete the process.

Drop Grade - There are many ways to do this, but here is my suggestion. Put a d (for drop) in front of the grade you want to drop. That way, you will be able to see the grade, but the computer will not calculate it in the average because it no longer reads it as a number.