With the 'Student1' box selected, hit CTRL + Enter, then drag down from the bottom-right corner of the box to fill in more student slots. If you're using Excel on a Mac computer, just note that the CTRL key for Windows will be the CMD key for Mac.ĭon't Miss: How to Create a Pass-Fail Grade Formula in Microsoft Excel Step 1: Fill in Basic Labelsįire up Excel, and start by adding labels for Attendance and Name, then use 'Student1' for the name name slot. This guide uses the latest Windows version of Excel, but these steps will work on all legacy versions of Excel for Windows and Mac OS X (now macOS), as well as Excel online. You'll also be able to create a print area where attendance totals are associated with their students. Autosum has been around a long time, and will work in all recent versions of Excel, including Excel Online (part ot the Office365 Suite) and versions on the Mac. Using the method outlined below, you can automate the entry of many fields, as well as total up attendance days using SUM and IF functions. With Autosum, Excel will automatically add up a range of cells for you, and place the result in a nearby cell.

With this software, you can create a simple yet functional attendance sheet to keep track of your students.

The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet.

Make a sum excel for mac