Setup Page to fit with invoice! HELPP ME PLZ!

You have margins of 9mm on both sides. Add that to the 214mm of the scanned form to make 232mm total. You can use the printer driver "scale to fit" or reduce the size of the picture using the sizing handles.

If this is just for printing purposes, you could scan to PDF and print that.

Excel typically distorts inserted objects when it comes to printing them. That's because Excel isn't a true wysiwyg program. Inserted objects will typically be shortened by 3-4% and widened by 6-7% when printed. You can confirm the actual distortion for your setup by inserting a large square or circle then printing the page containing it. If you calculate the horizontal & vertical distortions by measuring the printed size of the square or circle, you can re-scale the inserted object to compensate.

Are you trying to use the picture as a form over which you insert values? If that is the case, you would likely be further ahead designing the form in Word. Save it as a template and then use Excel as a source to fill in the form using Mail Merge.

As far as having control of output is concerned, Word allows you much better control. It is meant for output where Excel is primarily a "number cruncher" and not for printed output...in my opinion. Getting the values correctly placed in the form is another problem and Excel's picture handling is very rudimentary. Word will allow you to put a picture behind text so that both text and picture are visible.

Creating a form in Excel to have Excel fill out is a real pain and it is very difficult to get the visual results "right". At least, that has been my own experience.

Some of what you are seeing is what the printer is not allowing you to do and that is to fill the printed page from top edge to bottom edge and from left to right edges...borderless printing.

One way to get around the printer limitations in this area is to input a larger size in the page setup than what you are actually using. Use a custom paper size and set it to be 3-4mm larger in width and length than what you are actually using. Then you can set the margins to print exactly what you want. It takes set-up time but when perfected produces a good result.

Originally Posted by newdoverman

As far as having control of output is concerned, Word allows you much better control.

Indeed, But, aside from the object skewing in Excel, the set-up for printing on pre-existing forms isn't much less fiddly and a mailmerge for grouping multiple records per page (as you might have with an invoice or purchase order) isn't exactly straightforward.