in a format that worked for me, instead of the gradebook publisher.
Each worksheet has room for two weeks' worth of attendance and two grades per day for up to 34 students. At the end of the two week period, simply type in the date of the following Monday, and all the dates will change automatically.
You will only have to type in every student's name once. If you add a student, type his/her name at the bottom of the list, highlight any name in the list, and choose Sort from the Data menu. If a student leaves your class, simply delete the name, and Sort as before. The alternate row shading will not change due to sorting or adding/deleting a row.
Each of the three tabs can be renamed to match the class/period. Simply right-click on the tab, and choose Rename.
If you have more than three classes (who doesn't?), you can add additional ones by again right clicking any of the three tabs. Choose Move or
Copy, and in the dialog box that opens, click next to Make a Copy, and then click on (move to end).
To change the color of the new tab, right click on the tab, and choose Tab Color. Click on any color block that appears in the color palette.
You can then change the color of the font in cell A1 to match the tab color. Find the Font Color icon in the toolbar (it looks like a captial A)