How to print on pre-printed forms using Excel

Have you ever found yourself with a pre-printed form that needs to be filled in?

Using a typewriter is out of the question. One solution is a template that you can use and reuse to print the required information on the forms properly. Following are specific steps on how to print on pre-printed forms by creating a template in Excel and using the columns and rows as guidelines.

To print a pre-printed form using Excel, you’ll use the following:

Excel guide worksheet – includes a grid
Excel template – includes text boxes
You will then follow these steps to print on your pre-printed form using Excel — see link


How to Print on Pre-Printed Forms

Stuck with a preprinted form that needs to be filled out but your handwriting may not be that clear? Yes, we still get those once in a while, like the red 1099 form. Strangely enough, these forms may be scanned, and if the letters are not that clear, the information may not transfer properly and it can be a pain.  The IRS may send a letter saying that  the name and social security or employer ID don’t match, for example, because the 1099 scanned changed a letter in the person’s name.

Using a typewriter is out of the question, so, what can you do? You could use Excel to be able to print on the form properly.  Here is a quick tutorial with screenshots and pictures about how you can fill these forms using Excel —