How to Create Marksheet in MS Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to build a student marksheet in Microsoft Excel.

Quick summary

This tutorial shows you how to create a marksheet in MS Excel step by step, from setting up headers and data fields to using SUM and percentage formulas to calculate results automatically.

Steps

On a blank sheet, enter the headers and fields you want to include in your marksheet.
Input the data for each student into the table you just created.
Calculate the total marks by entering the SUM formula (e.g., =SUM(B2,C2,D2)) in the appropriate cell and pressing Enter.
Calculate the percentage by typing a formula such as =E3/300*100 in the designated cell.
Drag the bottom corner of the cell to autofill the formula for the rest of the table.

📌 Why this matters

Creating a marksheet in Microsoft Excel is one of the most practical ways to organize, calculate, and track student scores efficiently. Excel's built-in SUM and percentage formulas eliminate manual calculation errors and save significant time for teachers and administrators. Using the autofill feature to extend formulas across rows makes scaling a marksheet to any class size fast and reliable. Mastering this workflow gives educators a reusable, professional-grade grade tracker without needing any specialized software.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel