How to Make an Attendance Sheet in MS Excel
Here's how to do it:
- Open a new file, label the Excel sheet with appropriate headers and student names, or customize them as required.
- In this example, we will place the dates in this section of the header.
- Now, type the number '1' in the cell, and then drag the bottom corner of the cell to the right until you reach the desired number of days in the month.
- Once the cells are filled, click the table icon at the bottom to apply the table format.
- Click on "Fill Series."
- Each number now represents a day of the month.
- Type the corresponding day of the week above the number "1", then highlight the cells until you reach the last number.
- It will automatically fill in the corresponding day of the week for each date.
- Highlight the entire table.
- Next, click on ''Format as Table'' in the Excel ribbon and select a design to enhance the visual appeal of your table.
- Click "OK."
- You have now created an Attendance sheet.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it