# How to create marksheet in ms excel

> To create a marksheet in Excel, enter headers and fields on a blank sheet, input your data, calculate the total using the sum formula, compute the percentage with a division and multiplication formula, and drag the cell corner to automatically fill the rest of the table.

Canonical: https://livedemo.ai/tutorials/how-to-create-marksheet-in-ms-excel/
Apps: Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a39d7ab56e05a00fe0961/preview?step=1

## Steps

1. On a blank sheet, enter the headers and fields you want to include in your mark sheet.
2. Input the data that you have for the table you just created.
3. Calculate the total. In our case we do this by entering in the cell "=SUM (B2,C2,D2)," click on enter to finish.
4. To calculate the percentage, type =E3/300*100 in the cell, as shown in our example.
5. Finish by dragging the bottom corner of the cell to automatically fill in the rest of the table.