Скачать или смотреть How to create attendance sheet and do the page setup

Step 1: Create the Attendance Sheet Structure

Open Excel.

In Row 1, type the Title (e.g., “Monthly Attendance Sheet”).

Select the cell, merge across columns, make it bold, increase the font size, and center align.

In Row 2, type the Description (e.g., “Attendance record for September 2025 – Class A”).

Again, merge across columns, apply italic style if needed.

Starting from Row 4, create your table:

Column A → Serial No.

Column B → Student Name

Column C onward → Dates (1, 2, 3… up to 30/31).

Final column → Total Present.

Step 2: Apply Formatting

Use borders around the table.

Keep column widths wide enough for names and dates.

Highlight weekends/holidays in a different color if needed.

Step 3: Page Setup for Printing

Go to the Page Layout tab.

Under Page Setup:

Orientation → Landscape (better for attendance tables).

Size → A4.

Margins → Narrow or Custom (Top: 1", Bottom: 1", Left/Right: 0.5").

Click on the Print Titles option (Page Layout → Print Titles).

Under Rows to repeat at top, select the Title & Description rows (Row 1 & Row 2).

Go to Sheet tab → Tick Gridlines and Row & Column Headings if you want them.

Step 4: Add Header & Footer (Optional)

Go to Insert → Header & Footer.

Add items like Class Name, Month, Page Number.

Step 5: Preview & Adjust

Go to File → Print Preview.

Ensure the sheet fits to one page:

Use Fit Sheet on One Page (under scaling).

Or set Fit to: 1 page wide by 1 page tall in Page Setup.