If your users need to print some of the information in a Wrap, you may provide specially formatted print sheets that look better on paper than just a plain print or screenshot of the web page.
WrapCreator allows you to create one or more separate layouts just for printing. Typically, such a print sheet just copies information from other cells in the Wrap, using a more printer-friendly layout.
You designate the print sheet on the Sheets tab of the task pane. If you have created it specifically for printing, you may also want to hide the print sheet.
There is no limit to the number of print sheets you can select. In this case, they are probably ordinary tabs in the Wrap and you just want a few of them included in the print-out.
During printing, the Print sheet setting overrides all methods of hiding sheets. Whenever at least one Print sheet has been defined, the printout or PDF will include exactly all the designated Print sheets, regardless of their visibility, and no other worksheets.
Let’s face it – spreadsheets were never easy to print. Excel invites you to design in a landscape format that often becomes too wide for most printers.
Wraps can be tricky to print, too. They can be designed for legibility, which means there is a lot of guidance and helpful information. There can be excessive use of color and graphical symbols that isn’t optimized for printing.
If you are viewing a Wrap that uses responsive design for easier viewing on a narrow screen, printing it may create less than optimal results where only the left-most portion of each page is used.
To help you overcome issues like this, we designed the Print Sheet option. A print sheet is just like any other worksheet – you add text and formulas to it so that it contains the information you want to print. You can format the print sheet so that it fits the kind of printers you intend to use it with.
Let’s assume you have a Wrap where you have the user’s Name on one tab, the Address on a second, and the Phone on a third. Printing the contact information from the Wrap would always require three pages to be printed.
But when we press Print, the printed output actually looks like this:
This is because the form has a print sheet designated for it on the Sheets tab. The print sheet is not visible on the web page but automatically used when printing.
The layout of the print sheet is simple, it just aggregates the contents of the three wizard steps into one page.
The Print sheet does not have to be special in any way, it can be just any tab in the browser that is the only part of the page you ever want to print.
In Excel, you create a print sheet just like any other worksheet. Just click on the small plus sign to the right of the rightmost worksheet tab.
You can give a print sheet any name you like, as long as it follows our general guidelines. Double-click on the tab name to change it. To reorder the tabs, just drag them to the positions you want.
You select the print sheets by clicking on the corresponding printer symbols on the Sheets tab. To unselect a currently selected print sheet, click on the printer symbol again.
A print sheet is not hidden by default, but if you have created it specifically for printing it’s unlikely that you want the print sheet to be visible in the Wrap. You can hide it using the left-hand column, like in the example above. During the development of the print sheet, we recommend that you leave it visible so that the formatted result is visible.
The print sheet can be any sheet in the workbook. To create a separate print sheet just for printing, you can copy content from the visible, web-formatted worksheets to the hidden print worksheet. Just enter an equal sign in the field, switch to the other worksheet and click in the cell you want to copy.
In the example below
To print a multiline text field properly in a merged cell, ensure that you have enabled the Wrap text setting for the merged cell.
To format the page, you just use the ordinary Excel formatting options and verify the result on the screen.
For last-minute adjustment of the page width and height, we recommend that you use the print preview option in your web browser to see the page when it has been formatted for printing.
When you have done most of the design work, you may want to hide the print sheet using the settings on the Sheets tab.
