docs / articles / Create Printable Forms in Excel: A Step-by-Step Guide

Create Printable Forms in Excel: A Step-by-Step Guide

Sara Jul 09, 2026 2026-07-09 04:40:45

Creating printable forms in Excel can be a breeze once you understand the key steps involved. This versatile software allows you to design and print forms for various purposes, from invoices to questionnaires. Let's dive into the process, ensuring your forms are professional and functional.

How to Make a Fillable Form in Excel (5 Suitable Examples)
How to Make a Fillable Form in Excel (5 Suitable Examples)

Before we start, make sure your Excel version is up-to-date. For this guide, we'll be using Microsoft Excel 2016 or later, as the form features have been significantly improved in these versions.

Employment Application Template | Free Word Templates
Employment Application Template | Free Word Templates

Preparing Your Excel Workbook

Begin by opening a new or existing workbook. For a clean start, go to File > New > Blank workbook. Choose a sheet to work on, or insert a new one if needed. Name it appropriately, like 'Form1'.

Create a Data Entry Form in Excel [NO VBA NEEDED]
Create a Data Entry Form in Excel [NO VBA NEEDED]

Next, decide on the form's layout. Use columns for fields and rows for entries. For instance, if you're creating an invoice, columns could include 'Item', 'Quantity', 'Price', etc., and rows could represent each item or service.

Designing Your Form

FREE Tutorial - Excel Data Forms Mastery!
FREE Tutorial - Excel Data Forms Mastery!

Now that your workbook is set up, it's time to design your form. Start by adding headers and labels for each field. Use the Merge & Center function (Home tab, in the Alignment group) to combine cells for headers. Format these cells with bold text and a larger font size for emphasis.

Adding Form Fields

For each field, enter the label in the top cell (e.g., 'Item Name' in cell A1) and format it as described above. In the cell below, enter the formula '=IF(ISBLANK(A1),"",A1)' (without quotes). This will display the label in the field when the form is filled out.

Data Entry Form in Excel‼️ #excel
Data Entry Form in Excel‼️ #excel

To create a text entry field, select the cell (e.g., A2) and press Enter. The user can then type their response. For numeric fields, use the Number format (Home tab, in the Number group) to ensure accurate data entry.

Adding Form Instructions

Include clear instructions at the top of your form. Use a larger font size and bold text to make them stand out. For example, you might write 'Please fill out the form below and submit it to our accounting department.'

How to make printables in Microsoft Excel (step by step tutorials)
How to make printables in Microsoft Excel (step by step tutorials)

You can also add instructions within the form, such as 'Enter the item name here' or 'Please provide the quantity in whole numbers.' Use the same formatting as your headers to make these instructions easy to read.

Formatting and Customizing Your Form

Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
Material List Templates - Excel Word Template
Material List Templates - Excel Word Template
Data Entry Form in Excel
Data Entry Form in Excel
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
a screen shot of a web page with the text user form in green and white
a screen shot of a web page with the text user form in green and white
Free Excel Job Costing Template |
Free Excel Job Costing Template |
a printable budget sheet with the text 50 / 30 / 20 budget
a printable budget sheet with the text 50 / 30 / 20 budget
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
3 Excellent Sites to Get Free Document Templates
3 Excellent Sites to Get Free Document Templates
The ultimate excel templates you need
The ultimate excel templates you need
an invoice form with the words invoice written on it
an invoice form with the words invoice written on it
Construction Estimate Template | Word, Excel & PDF Format
Construction Estimate Template | Word, Excel & PDF Format
Excel course
Excel course
Making your dashboards interactive [Dashboard Essentials]
Making your dashboards interactive [Dashboard Essentials]
√ Free Printable Work Order Form
√ Free Printable Work Order Form
Create Fillable Forms in Word | Digital and Printable Forms
Create Fillable Forms in Word | Digital and Printable Forms
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
130+ Free Excel Tutorials
130+ Free Excel Tutorials
Free Excel Templates: 5 Best Websites for Budget & Business
Free Excel Templates: 5 Best Websites for Budget & Business

Once your form is designed, it's time to make it look professional. Use the Format tab (Home tab, click on the small arrow in the bottom-right corner) to apply styles, colors, and borders. You can also add images, such as your company logo, using the Insert tab.

Adding a Background Image

To add a background image, right-click on the sheet tab at the bottom and select View > Page Break View. Click on the Layout tab, then Print Titles, and select Custom Print Area. Enter the cells that make up your form, then click OK. Now, go to Page Layout > Page Background and select your image. Adjust the size and position as needed.

Once you've added your image, you can't move or resize it directly. To make changes, go back to the Custom Print Area and adjust the cells as needed.

Adding a Watermark

Watermarks can add a professional touch to your form. Go to the Page Layout tab, then Watermark. Select Custom Watermark and enter your text. Use a light gray font color for a subtle effect.

To preview your form, go to the File tab and select Print. Choose the printer you want to use, then click Print Preview. Make any necessary adjustments, then click Print when you're ready.

Congratulations! You've now created a professional, printable form in Excel. As you continue to use and customize your forms, you'll find that Excel offers a wealth of possibilities for creating exactly what you need. Happy designing!