How to Make an Attendance Sheet in MS Excel

Quick summary

This tutorial shows you how to create an attendance sheet in Microsoft Excel by setting up headers, auto-filling dates with Fill Series, mapping days of the week, and applying Format as Table for a clean, structured layout.

Steps

1. Open a new Excel file and label the sheet with column headers and student names, customizing them as needed.
2. Locate the header row where dates will be placed and identify the date columns section.
3. Type the number 1 in the first date cell, then drag the cell corner to the right to extend across the desired number of days in the month.
4. Click the table icon at the bottom of the selection to apply the initial table format.
5. Click Fill Series from the context menu to auto-populate sequential day numbers across the row.
6. Confirm that each number now represents a day of the month in the header row.
7. Type the starting day of the week above day 1, then highlight all cells through the last day number.
8. Excel will automatically fill in the corresponding day of the week for every date in the row.
9. Highlight the entire table to select all rows and columns of your attendance sheet.
10. Click Format as Table in the Excel ribbon and select a table design to enhance the visual appearance.
11. Click OK to confirm the table range and apply the selected format.
12. Your Excel attendance sheet is now complete with dates, days, and a formatted table layout.