The All-Purpose Checklist

Directions for Developing a Teacher Checklist using Excel

 

1.      Click on File on the menu bar, then Page Setup. Click on the Margins tab and set the Top margin to 0.75.  Set the Left margin to 1, the Bottom and Right margins to 0.5.  Click OK.

 

 

 

 

 

 

 

 

 


2.  Highlight Column A, Rows 1-31.  Select Format on menu bar, then Row and then Height.  Change Row Height to 20 and click OK.

 

 

 

 

 

 

 

 

3.  With Column A still highlighted, select Format on the menu bar, then Column, then Width.  Change Column Width to 30 and click OK

 

 

 

 

 

 

 

 

 

 

4.  Highlight cells B1:P1.  Select Format, then Column, then Width.  Change Column Width to 3 and click OK

5.  With cells B1:P1 still highlighted, select Format, then Row, then Height.   Change Row Height to 22 and click OK.

6.  Highlight cells A1:P31.  Then click on the Borders icon on the menu bar.  Click on the border that places a thick border on all sides.  Then click outside of the highlighted area

 


7.  Go to File on the menu bar, then Page Setup.  Choose the Sheet tab.  Click to put a check in the Gridlines box, then click OK.

 

 

 

 

 

 

 

 

 

8. Highlight cell A1.  Choose any font and font size you like and type in your name.  Student names can be added to cells A2:A31 when you are ready.