Print Control On Worksheet. If PrToFileName is not specified Excel prompts the user to enter the name of the output file. True to collate multiple copies.
WorksheetPrintOptions printOptions worksheetPrintOptions. If PrToFileName is not specified Excel prompts the user to enter the name of the output file. On the Page Layout tab Scale to fit group you will see a number of options.
Then just under the Quantity slider drop the Price slider on the sheet.
Then hit Add to Print Area. You can download or print using the browser document reader options. Print the first column and the first row on every page. WorksheetPrintOptions printOptions worksheetPrintOptions.