Worksheets

The Worksheet tab contains a spreadsheet much like many other spreadsheet programs. You can enter data and create mathematical functions here, as well as import and export data to other spreadsheet programs. This functionality is useful when you are creating spreadsheets for crew requirements, schedules, budgets, or any other show-specific data.

To import data

1. Select File > Import.
2. Select the file.
3. Click Open.

To export data

1. Select File > Export > Worksheet.
2. Enter the file name for your worksheet.
3. Click Save.

Note: For optimal compatibility with other WYG files, it is recommended that you export to the WYSIWYG Spreadsheet format (*.wss).

To export a worksheet template

For large shows, you may want to save the formatting of your worksheet as follows:

1. Select File > Export > Worksheet Template.
2. Enter the file name for your worksheet.
3. Click Save.

To create a new worksheet

1. Click the Worksheets shortcut tab.
2. Right-click in the worksheets shortcut area, and then choose New Worksheet.
3. Type the name of your new worksheet.
4. Click OK.

To insert smart cells

1. In your worksheet, select a cell.
2. From the menu, select Worksheet > Insert Smart Cell.

To insert pictures

1. In your worksheet, select a cell.
2. From the menu, select Worksheet > Insert Picture.
3. Select a photo in one of the supported formats (*.BMP, *.JPG, *.GIF, *.TIFF, *.PNG, *.TGA).
4. Click OK.

To sort data

1. Select a cell block that needs to be sorted.
2. From the menu, select Worksheet > Sort > Ascending/Descending.

Adding/removing rows and columns

To add a row

1. Select the cell above which you want to add a row.
2. From the menu, select Worksheet > Add > Row.

To remove a row

1. Select a cell in the row that you want to remove.
2. From the menu, select Worksheet > Delete > Rows.

To add a column

1. Select a cell to the left of which you want to add a column.
2. From the menu, select Worksheet > Add > Column.

To remove a column

1. Select a cell in the column that you want to remove.
2. From the menu, select Worksheet > Delete > Column.

Merging/unmerging cells

To merge cells

1. Select the block of cells that you would like to merge.
2. From the menu, select Worksheet > Merge Cells.

To unmerge cells

1. Select the block of cells that you would like to unmerge.
2. From the menu, select Worksheet > Unmerge Cells.

Zebra striping

To enable Zebra Striping on your worksheet

1. From the menu, select Worksheet > Zebra Striping.

Note: Currently there is only one set of alternating colors that you can choose.

Hiding headers

To hide the headers (the labeling of rows and columns)

From the menu, select Worksheet > Hide Headers.

Freezing panes

Freezing panes will lock a series of cells to the top of the working area no matter how much you scroll.

To freeze panes

1. Select the row below the section you want to freeze.
2. From the menu, select Worksheet > Freeze Panes.

Note: You can unfreeze panes by clicking Worksheet > Unfreeze Panes.

Formatting cells

Each cell has a configurable Type, Border, Alignment, Font, and Background. To access these options, select a cell (or block of cells), and then select Worksheet > Format Cells.

Exporting spreadsheets data to worksheets

Information from DATA mode spreadsheets can be automatically exported into a new PRES mode worksheet. This same data can then be inserted on a Layout if needed.

To export data to worksheets

1. In DATA mode, open the Spreadsheet tab.
2. From the File menu, choose Export to Worksheet.

Result: The Enter new Worksheet name dialog box appears.

3. Enter the name for the new worksheet which the data will be exported.
4. Click OK.

Result: The data is exported to PRES mode into a new worksheet.