version 2.1

   In this version you can choose between Print Sections and Print Ranges.

When you choose Print Sections, you will get this dialog:

This function helps you make printouts with multiple sections on one page. When you select this option Excel will make a copy of the sheet you want to print. The Print Sections Macro will be applied to the copy, not to the original. If you don't like the result, you can easily undo it by deleting the sheet with the unwanted formatting and try it again. The dialog contains the following controls:

Specify Source Range

This range box, in combination with the "select current region" button () allows you to quickly select the entire range that you want to reformat for printing in multiple sections.

Data Columns in selected range

This is the number of columns containing data for your print. Typically Spinnaker Prints suggests the correct number, you can specify more or less if you want to.

Data Sections per Page

Lets you specify how many sections of columns you want per page.

Empty Columns between Sections

You can specify to have zero columns between your sections, but usually you will choose one.

Rows in Column Headings

Sometimes a data file uses more than one row for the field names. You can specify how many rows this file uses for the Column Headings. The default is one.

Font Size in Output

When you specify a font size in this box, the row height will be set at 1.275 times the font size, and the rows per page will be calculated.

Row Height in Output

When you adjust this value, the number of rows per page of output will be recalculated.

Landscape

This checkbox will set the output to landscape, and recalculates the number of rows per page of output.

Rows per Page

This box displays how many rows will be fitted to one page. Though you can change this manually, increasing this number will increase the risk that your pages get messed up.

Specify Destination Range

If you specify a Destination Range, the output will be generated below, and to the right of the first cell in that range. If you don’t specify a Destination Range, a new sheet will be inserted, and the output will start in cell A1.

Help

This button activates this help file in the context of "Spinnaker Sections Prints".

OK

This will generate the print output according to the specifications of this dialog and display the resulting layout in print preview. If it turns out that not all data fits on the page as intended, you can choose to either redo it and specify less rows per page as needed, or you can go into page setup and adjust the scaling to something like 95%.

Cancel

This will cancel the print. It will also eliminate the copy of your data that was made to generate the Sections Print. (back to dialog)

The Print Ranges function allows you to define up to 5 ranges, which you can choose by selecting a range name, by scrolling in a worksheet, a combination of scrolling in a worksheet and the "select current region" button (), or a combination of all three of the mentioned methods. A new sheet will be inserted to which the selected ranges will be copied as values, retaining their formatting. The column width will be set to AutoFit. After that you can make changes as deemed necessary.

Range Name

You can select a named range in your current workbook. This is an easy way to select ranges, but you don't have to use it.

Range Reference

When you select a range name in the range name box to the left, the range reference will automatically appear in this box. When you click in a range reference box, you can click anywhere in a worksheet to make a selection to print on the new sheet. You can expand or diminish the selection by scrolling in the range or typing in the range reference box. You have to make sure however that your references are valid, otherwise your results will not be as expected.

OK

This will generate the print output according to the specifications of this dialog.

Cancel

This will cancel the whole operation. It will also eliminate the new sheet that was inserted to generate the Ranges Print.

Reset

This will reset all the boxes, so you can specify a whole new Ranges Print.

Help

This button activates this help file in the context of "Spinnaker Ranges Prints". (back to dialog)