docs / articles / Mastering Excel: Create Printable Forms in a Snap

Mastering Excel: Create Printable Forms in a Snap

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

Creating a printable form in Excel can be a breeze once you understand the key steps. This versatile software allows you to design professional-looking forms for various purposes, from surveys to invoices. Let's dive into a step-by-step guide to help you create your printable form effortlessly.

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

Before we begin, ensure you have the latest version of Microsoft Excel installed on your computer. For this guide, we'll use Excel 2016, but the process is similar in other versions. Now, let's get started!

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

Setting Up Your Form

First, open a new or existing workbook in Excel. For a clean slate, click on 'File' > 'New' > 'Blank workbook'. Next, decide on the form's layout. You can use a single page or multiple pages, depending on your needs. For this guide, we'll create a single-page form.

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

To set up your form, click on 'Page Layout' in the ribbon. Here, you can customize the margins, orientation, and paper size. For a standard letter-sized form, use the following settings: 'Orientation' - Portrait, 'Paper size' - Letter, and adjust the margins as needed.

Adding Form Fields

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

Now that your form is set up, it's time to add fields. Form fields can include text boxes, dropdown menus, checkboxes, and more. To add a text box, click on the 'Developer' tab in the ribbon (if it's not visible, go to 'File' > 'Options' > 'Customize Ribbon' and check 'Developer'). Then, click on 'Insert' and select 'Text Box'.

To create other field types, use the 'Form Controls' group in the 'Developer' tab. For example, click on 'Combo Box' to create a dropdown menu, or 'Check Box' to add a checkbox. Customize each field by right-clicking and selecting 'Format Control'. Here, you can set input restrictions, default values, and more.

Designing Your Form

Data Entry Form in Excel
Data Entry Form in Excel

To make your form visually appealing, use Excel's formatting tools. You can add headers, footers, borders, and shading to separate sections. To add a header or footer, click on 'Insert' in the 'Page Layout' tab, then select 'Header' or 'Footer'. Customize them using the 'Design' and 'Options' tabs that appear.

To add borders and shading, select the cells you want to format, then click on the 'Borders' or 'Fill Color' icons in the 'Home' tab. You can also use the 'Merge & Center' option to combine cells and create titles or headings.

Preparing Your Form for Printing

Create Custom Spreadsheets & Templates in Microsoft Excel for Organization & Planning
Create Custom Spreadsheets & Templates in Microsoft Excel for Organization & Planning

Before printing, ensure your form looks perfect on the page. Use the 'Page Break Preview' button in the 'View' tab to see how your form will print. If needed, adjust the page breaks by clicking and dragging the page break icons that appear.

To preview your form, click on the 'File' tab, then select 'Print'. Here, you can choose the printer, paper size, and other settings. Click on 'Print Preview' to see how your form will look when printed. Make any necessary adjustments before proceeding.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
How To Create Printable Forms in Word – Make Your Fillable Form Printable
How To Create Printable Forms in Word – Make Your Fillable Form Printable
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
How to Create a Database with a Form in Excel - ExcelDemy
How to Create a Database with a Form in Excel - ExcelDemy
How to make printables in Microsoft Excel (step by step tutorials)
How to make printables in Microsoft Excel (step by step tutorials)
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
Excel course
Excel course
Creating Easy Data Entry Forms in Excel
Creating Easy Data Entry Forms in Excel
Design a Form Filling Database Using Microsoft Access.
Design a Form Filling Database Using Microsoft Access.
3 Excellent Sites to Get Free Document Templates
3 Excellent Sites to Get Free Document Templates
a printable budget sheet with the text 50 / 30 / 20 budget
a printable budget sheet with the text 50 / 30 / 20 budget
How to Create a Database in Excel [Guide + Best Practices]
How to Create a Database in Excel [Guide + Best Practices]
Create Fillable Forms in Word | Digital and Printable Forms
Create Fillable Forms in Word | Digital and Printable Forms
How to Create a Fillable Form in Word | Microsoft Word Tutorials
How to Create a Fillable Form in Word | Microsoft Word Tutorials
Making your dashboards interactive [Dashboard Essentials]
Making your dashboards interactive [Dashboard Essentials]
VBA UserForm
VBA UserForm
The ultimate excel templates you need
The ultimate excel templates you need
the advanced excel chart sheet is shown in green and has instructions on how to use it
the advanced excel chart sheet is shown in green and has instructions on how to use it
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

Printing Your Form

Once you're satisfied with your form's layout and design, it's time to print. Click on the 'File' tab, then select 'Print'. Choose the number of copies you need and select any other desired settings. Finally, click on 'Print' to send your form to the printer.

If you need to print multiple copies of the same form, consider using the 'Print Area' feature. Select the range of cells containing your form, then click on the 'Page Layout' tab. In the 'Page Setup' group, click on 'Print Area' and select 'Set Print Area'. This ensures that only your form prints, even if other data is present in the workbook.

Congratulations! You've successfully created and printed a professional-looking form using Excel. With a little practice, you'll be designing and printing forms in no time. Happy creating!