The Print sheets

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.

Screenshot of the Sheets tab with a designated 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.

Screenshot of the Sheets tab with two print sheets

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.

The need for a separate print sheet

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.

Screenshot of a wide spreadsheet in Excel

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.

Screenshot of a colorful web survey

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.

Screenshot of a web page with responsive design

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.

Using a print sheet

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:

The printed output of a wizard with a print sheet

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.

Screenshot of the Sheets tab with a designated print sheet

The layout of the print sheet is simple, it just aggregates the contents of the three wizard steps into one page.

Screenshot of a print sheet in Excel

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.


Create the print sheet

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.

Screenshot of the "add worksheet" button in Excel

Name the print sheet

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.

Screenshot o a tab being renamed in Excel

Select the print sheet

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.

Screenshot of the Sheets tab with a designated print sheet

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.

Fill the print sheet with content

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

  1. we selected cell B3 in the Print sheet
  2. clicked on the Name tab
  3. selected cell B1
  4. pressed Enter.

Screenshot of a print sheet in Excel

Use Wrap Text for multiline text fields

To print a multiline text field properly in a merged cell, ensure that you have enabled the Wrap text setting for the merged cell.

Screenshot of the Wrap Text setting for a multiline text field

Format a print sheet

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.