How to Use Excel for W-2 Form Printing | Sapling

How to Use Excel for W-2 Form Printing

Written By
ST
Sapling Team
Jun 5, 2008
2 minute read

How to Use Excel for W-2 Form Printing. Operating a small business has many responsibilities from employee management to customer service. Organizing and assembling tax information for the business can be an especially time consuming process. To make tax time easier you can use Microsoft Excel for W2 form printing.

Step 1

Assemble all the necessary tax information for each employee. All the information required is available on the Internal Revenue Service website. See the Resources section below for more information.

Step 2

Locate and Download the Microsoft Office W2 template from the Microsoft website (see Resouces). Once at the W2 template click on the "Download" button to initiate template installation.

Step 3

Install the Microsoft Excel W2 template file. After clicking on the download, chose "Install" to begin the template installation. You have to "Enable Scripts" if you are using pop-up blocker or Internet security software. To do this, right-click on the warning instruction and enable the installation.

Step 4

Open the W2 Excel form in Microsoft Office. Click on "Start" from the main operating system menu. Then choose "Programs" or "All Programs" from the start menu. Next, select "Microsoft Office" from the programs menu. Now choose "Microsoft Excel" from the Microsoft office menu. Finally click "New" from the main file menu of Microsoft Excel, select "Installed Templates", and choose the "W2" template.

Advertisement

Step 5

Fill out the W2 template with information assembled in Step 1. Then select "Print" from the mail file menu.

resources
Sapling Logo

We demystify personal finance and make financial adulting easier. From student loans to credit and investing, all the money questions you were ever afraid to ask are right here.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.