Using Excel to automate a preprint form?

[Guest]

I would like to use Excel with preprinted forms by somehow import an image of
the form and adjusting the rows and columns in order to supply the variable
data. Specifically tax forms.

 

[Guest]

Zero

I have tried this myself and it is really difficult.

In both case set the columns to width 1 so that you have many columns.

One way that I did it was to reconstruct the form in the excel window and
import the images.

The otherway I did it was to set up the cells and mask the form with an
imput sheet links to the blank sheet with only the data.

both ways are time consuming but work ok.