Printing Problems

How to Print Excel's Built-In Data Entry Form

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

The user wants to print Excel's built-in data entry form as a paper record.

How to Print Excel's Built-In Data Entry Form
Product
Microsoft Excel
Device & OS
not provided
Scenario
Create a printed form for inventory or other data-entry activities.
Observed behavior
Excel's built-in data entry form does not have a direct print command.
Before you start

Open the workbook and select a cell in the data list or table. If the Form command is not visible, add it to the Quick Access Toolbar through Excel's toolbar customization options.

Solution 1Recommended

Print a Screenshot of Excel's Data Entry Form

Use this method to print the form as it appears on screen, including the currently displayed record.

1
Open the form

Select a cell in your data list, then click Form on the Quick Access Toolbar. Navigate to the record you want to print.

2
Capture the form

Use your device's screenshot tool to capture the form window. On Windows, you can press Windows+Shift+S and select the form area.

3
Paste the image

Open an image editor or document, then use Paste to insert the screenshot. Crop or resize it if needed.

4
Print the screenshot

Choose File > Print in the editor or document, check the print preview, and select Print.

Print a Screenshot of Excel's Data Entry Form
Printing multiple records: A screenshot captures only what is visible. Navigate to each record and capture it separately if you need more than one.
Free Microsoft Office alternative

Create Printable Worksheet Forms in WPS Office

WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface. Open an Excel workbook in WPS Spreadsheet and create a printable worksheet form for a straightforward move between office suites.

Design reusable inventory and data-entry forms in a worksheetOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for an easier transitionPreview and adjust worksheet pages before printing
microsoft office alternative - wps office

Frequently Asked Questions

Can I print Excel's built-in data entry form directly?

No. The built-in form has no direct print command. Capture a screenshot of the form, paste it into an editor or document, and use File > Print.

How do I add the Form command in Excel?

In Excel's Quick Access Toolbar customization options, find Form in the list of available commands and add it to the toolbar. Then select a cell in your data list and click Form.

Will a screenshot print every record in my data list?

No. It captures only the form and record visible on screen. Navigate to another record in the form and take a separate screenshot to print it.

How can I print a blank form for handwriting?

Create a worksheet with field labels and blank entry cells, select the form, and choose Page Layout > Print Area > Set Print Area. Then use File > Print to preview and print it.