SaltfishTry for free

How to Create Marksheet in MS Excel

·1 min read
In this article

Here's how to create marksheet in MS Excel

  1. Set up your marksheet by creating column headers for student names, subjects, totals, and percentages on a new worksheet.
  2. Fill in the student data and subject scores in the rows beneath your header columns.
  3. Create a total column by entering the SUM formula (=SUM(B2,C2,D2)) in the appropriate cell and pressing Enter.
  4. Add percentage calculations by typing the formula =E3/300*100 in the percentage column cell.
  5. Copy the formulas to remaining rows by selecting the formula cell and dragging the fill handle down to auto-populate the entire table.

Ready to get started with
interactive demos?

Try for free

Frequently Asked Questions

Yes, you can change the 300 in the formula =E3/300*100 to match your actual total possible marks. For example, if your total possible marks is 500, use =E3/500*100 instead.