Printing Multiple worksheets in Excel
Printing Multiple worksheets in Excel
(OP)
Hi guys quick question for you.
Most of the spreadsheets I work with a multiple sheets, I tend to print out all these sheets at once by selecting all the tabs and hitting print. The problem comes with making pdf files, where many of my spreadsheets will try to seperate out.
For example a 5 page workbook will try to make a pdf file for page 1, a file for pages 2-4 and a file for page 5. (I guess this may be happening unnoticed with hard copy prints too thinking about it). This also happens occasionally in word. Obviously I can then merge these 3 documents, but its an annoyance I could do without.
I assume there is some sort of section break in action here that is splitting these files up, but I can't for the life of me find it, does anybody have any suggestions please?
Most of the spreadsheets I work with a multiple sheets, I tend to print out all these sheets at once by selecting all the tabs and hitting print. The problem comes with making pdf files, where many of my spreadsheets will try to seperate out.
For example a 5 page workbook will try to make a pdf file for page 1, a file for pages 2-4 and a file for page 5. (I guess this may be happening unnoticed with hard copy prints too thinking about it). This also happens occasionally in word. Obviously I can then merge these 3 documents, but its an annoyance I could do without.
I assume there is some sort of section break in action here that is splitting these files up, but I can't for the life of me find it, does anybody have any suggestions please?





RE: Printing Multiple worksheets in Excel
RE: Printing Multiple worksheets in Excel
Goto last cell also has not shown anything, each worksheet is printing off as one page, the problem I am having is the workbook isn't printing off as a single entity
RE: Printing Multiple worksheets in Excel
I have just assembled the separate pdf files into one file using pdftk.
RE: Printing Multiple worksheets in Excel
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Printing Multiple worksheets in Excel
I use Neevia docuPrinter Pro v5.x to print to PDF format and have not experienced any problems with multiple files or banners when printing more than one tab at the same time.
http://www.neevia.com
RE: Printing Multiple worksheets in Excel
This is due to the worksheets having different print qualities.
To make a single .PDF when printing multiple Excel worksheets, MAKE SURE ALL WORKSHEETS HAVE THE SAME PRINT QUALITY.
To do this, for EACH worksheet, go to File-> Page Setup-> Print Quality and set to the same figure.
RE: Printing Multiple worksheets in Excel
RE: Printing Multiple worksheets in Excel
RE: Printing Multiple worksheets in Excel
RE: Printing Multiple worksheets in Excel
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.