The Worksheets tab

The Worksheets tab lets you select the worksheets that will be visible on the web page. If your users need to print some of the information in a form or calculator, you may provide a specially formatted print sheet. 

The Worksheets tab of the SpreadsheetConverter task pane contains a list of all the worksheets in the workbook you are currently editing with Excel.

Show/hide worksheets in the web page

When there’s more than one worksheet in your workbook, we automatically hide all but the first during the conversion to a web page. This is because an overwhelming majority of the workbooks with two or more worksheets use only the first worksheets for display – the rest of the worksheets just provide background information for the “front page”.

 Screenshot of the Worksheets tab with two worksheets automatically hidden

If you want to make more than one worksheet visible in the converted web page, uncheck them in the list before you convert the spreadsheet. We offer various techniques to display multi-section forms and calculators, e.g. with tabs, as a wizard or with sliding panels. Read more about multi-section forms.

Selecting a 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 a screenshot of the web page.

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 the currently selected print sheet, click on the printer symbol again.

Screenshot of the Worksheets tab in SpreadsheetConverter

The print sheet is not hidden by default, but it’s unlikely that you want the print sheet to be visible in the converted web page. In most cases, you should hide it using the left-hand column, like in the example above. During the development of the print sheet, you may want to leave it visible so that the formatted result appears in the Live Preview.

There is a help page about Print Sheets.