How to Make a Bill in Excel
Making a bill in Excel is simple — build a table, list the items, and let formulas work out the totals. Per Microsoft, a formula always starts with =, and AutoSum inserts the SUM function for you.
What you'll learn in this guide
- Building the bill table
- Using formulas for totals
- Using AutoSum for the subtotal
1Build the bill structure
Business details, customer details and a table.
- Open Excel and start a new blank workbook.
- At the top, write your business name, bill number and date.
- Below that, write the customer's name and details.
- Write the table headings — Item, Quantity, Unit Price, Total.
- Select the data, go to Insert > Table, tick My table has headers and click OK.
2Work out totals with formulas
Let formulas do the maths — type once, copy down.
- Enter each item's quantity and price.
- In the Total column, type a formula such as Quantity × Unit Price, and press Enter.
- For the subtotal, use AutoSum in the cell below the table — choose AutoSum from the Home or Formulas tab, then press Enter.
- If tax applies, multiply the subtotal by the tax rate, then add subtotal and tax for the grand total.
3Save and print
Preview once before printing.
- Save the file and preview it once before printing.
💡 Pro Tip
Do not retype the total formula — copy the first cell's formula down to the other cells; Excel adjusts it automatically for each row.
Frequently asked questions
How do you start a formula in Excel?
Every formula starts with an equal sign =, followed by numbers and operators such as +, −, * or /.
What does the SUM function do?
SUM adds the numbers in a column or row — for example, =SUM(A1:A2) adds A1 and A2.
How do you use AutoSum?
Select the cell immediately below the numbers you want to add, choose AutoSum from the Home or Formulas tab, and press Enter.
How do you make a table in Excel?
Enter the data, select any cell within it, go to Insert > Table, check the range and My table has headers, then click OK.
Does Excel have a ready-made bill template?
The Microsoft Support page links to Download free, pre-built templates; starting from a template is also an option.