Tuesday, January 26, 2010

Excel Tip

Here is an update for the Excel Tricks and Tips.

This was not included on the handout.


How to get your students at the top of every page of your mastery without copy and pasting the row at the top of each page. This is for printing purposes and this is different than freezing the panes that we did in the inservice.


To Repeat Rows (names of students) for Mastery

View > Page Layout

File > Page Set Up

Sheet tab

Print Files > Rows to Repeat at Top Click on grid at end of box.

Highlight the row of your worksheet where the students' names are. You should see a formula appear in the box with $ signs.

Click OK. Now at the top of each page will be the students' names.