The Print sheet

If your users need to print some of the information in a form or calculator, you may provide a specially formatted print sheet that looks better on paper than just a plain print or screenshot of the web page.

SpreadsheetConverter allows you to create a separate layout just for printing. Typically, such a print sheet just copies information from other cells in the web form, using a more printer-friendly layout.

You designate the print sheet on the Worksheets 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 Worksheets tab with a designated print sheet

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

Web pages 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 web page 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 little “wizard” as we call them, a web form consisting of multiple steps.

The first step asks for some information, after which the user presses Next.

Screenshot of the first step of a wizard

The second step asks for some other information, then Next.

Screenshot of the second step of a wizard

There is also a third step in the wizard.

Screenshot of the third step of a wizard

Printing this form would require three printed pages, with very little information on each page.

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 Worksheets tab. The print sheet is not visible on the web page but automatically used when printing.

Screenshot of the Worksheets 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.

Details

Printing operations

SpreadsheetConverter supports three printing operations:

  • Print All – prints all worksheets separately, without using the print sheet.
  • Print This – prints the current worksheet, without using the print sheet.
  • Print – prints the print sheet. If a print sheet hasn’t been selected, it prints the current worksheet.

If you initiate the print operation from the web browser with the Print menu option or the Ctrl-P keyboard shortcut, it corresponds to the Print operation in the list above.

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 sheet by clicking on the corresponding printer symbol on the Worksheets tab. Only one worksheet can be selected as the print sheet. To unselect a currently selected print sheet, click on the printer symbol again.

Screenshot of the Worksheets 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 web page. 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 in the Live Preview.

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 use Live Preview to 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 Worksheets tab.