|
Microsoft Excel |
Top Previous Next |
|
If you are creating a PDF file from an Excel workbook that contains multiple worksheets, selecting the "Entire workbook" option from the Excel print dialog will create a separate PDF file for each worksheet. If you would like to have all worksheets in a single PDF file, you can select multiple worksheets before printing to the Win2PDF printer.
You can select multiple worksheets by holding down the "shift" or "control" key while clicking on the sheet tab. Select the "Print..." command from the "File" menu and make sure "Active sheet(s)" is enabled in the Excel print dialog. More information on selecting multiple worksheets is available at: http://office.microsoft.com/en-us/assistance/HP052024921033.aspx
Alternatively, if you select "print to file" from the Excel print dialog all worksheets will be created in a single PDF file.
|