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.
No comments:
Post a Comment