"Create Simple Invoice in Excel: Step-by-Step Guide"

Katherine Jul 11, 2026

Creating an invoice in Excel is a straightforward process that can save you time and ensure professionalism in your business transactions. Whether you're a freelancer, small business owner, or need to create invoices for your organization, this guide will walk you through the steps to create a simple yet effective invoice in Excel.

How to Create a Business Invoice in Excel - Tutorial
How to Create a Business Invoice in Excel - Tutorial

Before we dive into the process, ensure you have Microsoft Excel installed on your computer. For this guide, we'll use Excel 2016, but the steps are similar in other versions as well.

Cost Tracking Spreadsheet - how to create an invoice in excel Hindi
Cost Tracking Spreadsheet - how to create an invoice in excel Hindi

Setting Up Your Invoice Template

To create an invoice in Excel, you'll first need to set up a template with the necessary fields. You can create this from scratch or use a pre-built template for a head start.

Invoice Format in Excel | Free Download
Invoice Format in Excel | Free Download

To access pre-built templates, open Excel and click on "File" > "New" > "From Template". Browse through the available templates, and choose one that suits your needs. For this guide, let's assume you've chosen a blank workbook to create your invoice from scratch.

Defining Invoice Sections

How to Create Invoice Bill in Excel & Numbers on Mac & PC
How to Create Invoice Bill in Excel & Numbers on Mac & PC

Your invoice should typically include the following sections: invoice header, customer details, itemized services or products, subtotals, taxes, and totals. Let's set up these sections in your Excel worksheet.

In Row 1, enter the following headers: "Invoice No.", "Date", "Due Date", "Bill To", "Address", "City", "State", "Zip", "Phone", "Email", "Item/Service", "Quantity", "Rate", "Amount", "Tax", "Total". Format these headers as you see fit, using bold text, fill colors, or borders to make them stand out.

Freezing Invoice Header Rows

two invoices with the words how to create an invoice in excel
two invoices with the words how to create an invoice in excel

To keep your invoice header visible while you scroll through the rest of the data, you'll want to freeze the top rows. Select Row 6 (or any row below your headers), click on the "View" tab, then "Freeze Panes", and finally "Freeze Top Row". Now, your invoice header will remain visible as you scroll down.

You can also freeze multiple rows by selecting the row below the range you want to freeze, then choosing "Freeze Panes" > "Freeze Top Rows" and entering the number of rows you want to freeze.

Populating Your Invoice with Data

Free Invoice Template  | Download for free
Free Invoice Template | Download for free

Now that you have your invoice template set up, it's time to populate it with data. You can either enter the data manually or use formulas to automate the process.

For manual entry, simply fill in the relevant information in each column. To maintain consistency, consider using data validation to limit the types of data that can be entered into specific cells. For example, you can set up data validation for the "Quantity" and "Rate" columns to accept only numeric values.

16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF
Free Invoice Template -  How To Create an Invoice Using Google Docs Invoice Template
Free Invoice Template - How To Create an Invoice Using Google Docs Invoice Template
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
an invoice form is shown with the name and number on it, as well as
an invoice form is shown with the name and number on it, as well as
an invoice form with the words invoice written on it
an invoice form with the words invoice written on it
Invoice Templates Made Simple with Google Sheets
Invoice Templates Made Simple with Google Sheets
Beautiful Invoicing templates for Free
Beautiful Invoicing templates for Free
Free Invoice Template using Excel - Download today - Create, print or save PDF invoices instantly using this
Free Invoice Template using Excel - Download today - Create, print or save PDF invoices instantly using this
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Create a Professional Invoice Template in Word — No Excel Needed!
Create a Professional Invoice Template in Word — No Excel Needed!
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
how to create Bill invoice Entry  in excel with formula
how to create Bill invoice Entry in excel with formula
How to create professional invoice for freelance work
How to create professional invoice for freelance work
Step-by-Step Guide: Create a Professional Invoice in Google Sheets Easily!
Step-by-Step Guide: Create a Professional Invoice in Google Sheets Easily!
How to Customize Invoices in QuickBooks
How to Customize Invoices in QuickBooks
Small Business Invoice Template for Home Office | Download Now
Small Business Invoice Template for Home Office | Download Now
Sales Invoice Excel | Templates at allbusinesstemplates.com
Sales Invoice Excel | Templates at allbusinesstemplates.com
Creative with Colourful GST Invoice Format in Excel (Download .xlsx file)
Creative with Colourful GST Invoice Format in Excel (Download .xlsx file)
Free Excel Invoice Templates
Free Excel Invoice Templates
Freelance Invoice Template | Black and White Minimalist Design
Freelance Invoice Template | Black and White Minimalist Design

Using Formulas for Automatic Calculations

To save time and ensure accuracy, use Excel formulas to automatically calculate subtotals, taxes, and totals. In the "Amount" column, enter the formula "=Quantity * Rate" to calculate the amount for each item or service. Then, in the "Tax" column, enter the formula "=Amount * Tax Rate" (replace "Tax Rate" with the appropriate tax rate, e.g., 0.07 for 7% tax).

To calculate the subtotal, enter the formula "=SUM(Amount)" in a cell below the "Amount" column. For the total, enter the formula "=Subtotal + SUM(Tax)" in a cell below the "Tax" column. These formulas will automatically update as you add or modify items in your invoice.

Formatting Your Invoice

To make your invoice visually appealing and professional, apply some formatting touches. You can add a logo, change font styles and sizes, use colors, and apply borders and shading to highlight important information. Don't forget to proofread your invoice for any spelling or grammar errors.

You can also add payment terms, notes, or a message to your customer at the bottom of the invoice. To do this, insert a new row below the "Total" and enter the relevant text. Format this text as desired, using a smaller font size and light shading to make it stand out less than the main invoice data.

Congratulations! You've now created a simple yet professional invoice in Excel. With this template, you can quickly generate invoices for your clients, ensuring a consistent and polished look for your business transactions. As your business grows, you can further customize your invoice template to include additional features, such as payment status tracking or invoice numbers that auto-increment.