Freeze panes: (Column A and Rows 1 and 2 will stay on the viewing screen): Place the cursor in cell B3, go to Window and choose Freeze Pane.
Print the grid and row and column headings: Go to File and choose Page Set-up. Choose the Sheet tab and select Gridlines and Row and Column headings.
Repeat Column A and Rows s 1 and 2 on each printed page: Go to File and choose Page Set-up. Choose the Sheet tab. Place your cursor in the white field beside "Rows to repeat top" and type $1:$1. Place your cursor in the white field beside "Columns to repeat left" and type $A:$B.
Change the page format: Go to File and choose Page Set-up. Choose the Page tab. Choose Portrait or Landscape. Also, use the Fit to button to compress your document to a certain number of pages.
Print a graph on a full page: Select the graph and print. If you want the graph to be one the same page as the data be sure that the graph is not selected.
Headers and Footers: If you and your partner work at the same computer, be sure to include both your names on all work. Go to File and choose Page Set-up. Choose the Header/Footer tab. Use Custom header and custom footer to enter information (your names, the date, the course number) you want to appear on each page of your file.
The text box: Activate the Drawing tool bar and click on the icon containing an A in its upper left corner. Use the text box to write comments as well as the formulas you entered into the cells. This will help you recover what you did a year from now when you want to use it in a lesson. It also lets me see how your formulas look so I can help correct possible mistakes.
Add a button to the tool bars: Go to View, choose Tool bars, then choose customize. The Commands tab lets you see all buttons available. Highlight a button, grab it and copy it to the toolbar. A customized tool bar can be a big time saver. Unfortunately, Excel has no button for superscript and subscript, but Word does. Check it out.
Format the cells: Go to Format cell and pick the number tab. Choose "number" under Category and check the "Use 1000 Separator (,)" box. Choose at most 2 for number of decimal places. To print the numbers in scientific notation, choose "Scientific" under Category. Use one or two decimal places.