ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to print specified cells to a pre-designed and printed form (https://www.excelbanter.com/excel-discussion-misc-queries/167087-how-print-specified-cells-pre-designed-printed-form.html)

Andy1806

How to print specified cells to a pre-designed and printed form
 
I want to print text from cells to a pre-designed/printed form. I have
duplicated a pre-designed form in a worksheet but now want to print just the
text in the cells to the pre-designed form hard copy.

Gord Dibben

How to print specified cells to a pre-designed and printed form
 
You have a pre-printed form in your paper tray but it needs some data filled in?

By trial and error you could manipulate the placement of the text cells in your
worksheet so's they printed on the form in the paper tray.

No easy way to do this.

Have lots of pre-printed forms handy in your tray.

Make sure you have gridlines disabled in Page SetupSheet settings.

But, you say you have "duplicated" the form in your worksheet.

Why not just print that onto blank paper?


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 14:51:00 -0800, Andy1806
wrote:

I want to print text from cells to a pre-designed/printed form. I have
duplicated a pre-designed form in a worksheet but now want to print just the
text in the cells to the pre-designed form hard copy.




All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com