The Sheets tab

The Sheets 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 Sheets tab of the task pane contains a list of all the worksheets in the workbook you are currently editing with Excel. You can hide all the background sheets that you don’t want to be visible in the wrap. You can hide or lock worksheets for users without the required permissions. A special worksheet can be used when printing a wrap.

Screenshot of the Worksheets shortcut to the WrapCreator task pane

Hide background worksheets in the wrap

When there’s more than one worksheet in your workbook, we automatically hide all but the first during the conversion to a wrap. 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 Sheets tab

If you want to make more than one worksheet visible in the converted web page, click on the corresponding “eye” symbols in the list so that they turn green before you convert the spreadsheet.

By default, each worksheet appears as a separate tab in the wrap.

If you add a new worksheet to the Excel workbook, it may not be immediately visible in this list, To refresh the list, click on the Refresh button at the top.

Lock or hide sheets by role

Removing redundant detail from a Wrap can be useful to reduce the technical complexity of a Wrap for office workers. You may want to show information in a read-only mode for users that aren’t authorized to edit it. You can lock or completely hide a tab on the Sheets tab, depending on the user’s roles.

You set the roles that lock or hide each tab separately in the list of worksheets on the Sheets tab. Navigate to the sheet in question and a Lock or Hide dialog will pop out when you hover your mouse over the corresponding column. In both cases, you are expected to select user roles.

Screenshot of the Lock Sheet option on the Sheets tab in the task pane

You may lock a tab

  • if the user has a certain combination of roles – the user is qualified
  • if the user does not have this combination of roles – the user is not qualified.

The methodology you choose largely depends on your business requirements, but also on convenience – when it comes to roles, it’s always best if the definition is as brief as possible to reduce the risk of errors. If a tab is meant to be updated only by users with a few particular competences, and you want to lock it for all other roles, you will probably end up listing the few qualified roles and using the option (lock the sheet if the user is) not qualified.

Select the first role that makes users qualified. If additional roles are required for a user to be qualified, add them to the same group. A user must have all the roles in a group to qualify, e.g. “users must be both Administrator and Supervisor”.

To add an alternate combination of roles that also makes users qualified, click on New Group and add all the roles to the new group that a user must alternatively have. A user must have all the roles in at least one of the groups to qualify.

  • If you lock a tab if the user is qualified, the tab will be locked for users that have all the roles in at least one of the groups.
  • If you lock a tab for users that are not qualified, the tab will be locked for users that do not have all the roles in any of the groups.

Again, use the locking methodology that you find the easiest to define.

Hide sheets by role

When you lock a worksheet, its tab is still visible in the Wrap, but the fields cannot be modified. If you want to make a tab invisible for certain users, you can hide it completely. The role definitions that hide sheets work exactly like when you lock sheets as described above.

Screenshot of the Hide Sheet option on the Sheets tab in the task pane

  • If you hide a tab if the user is qualified, the tab will not be visible for users that have all the roles in at least one of the groups.
  • If you hide a tab for users that are not qualified, the tab will not be visible for users that do not have all the roles in any of the groups.

Selecting print sheets

If your users may need to print some of the information in a Wrap, you can provide a specially formatted print sheet that looks better on paper than just a plain print or a screenshot of the browser tab. If you want to print a few of the tabs as they are, any combination of tabs can be selected as print sheets.

You select a sheet for printing by clicking on the corresponding printer symbol on the Sheets tab. Any number of worksheets can be selected for printing. To unselect a currently selected print sheet, click on the printer symbol again.

Screenshot of the Sheets tab with two print sheets

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 converted web page. You can hide it by clicking on the eye symbol in the left-hand column until it’s red.

There is a help page about Print Sheets.