Printing Excel Tabs to Adobe PDF

boonwd

New Member
Joined
Jul 21, 2015
Messages
10
Greetings to the forum,
i have a situation that's not new to me but i decided to try to find a remedy.
when i attempt to print to a PDF using Adobe more than one tab or sheet from a workbook, Adobe will begin to print the first tab selected and ask “where to and what name”.
it prints the first selected tab and then up pops the “where to and what name window again”. I have to give the second print effort a “dummy” name to get it to move forward, and repeat this until all the selected tabs are printed to PDF.
Once that effort is competed, I have to then combine or bind all the dummy PDFs into a single PDF file, which was my original intent in the first place. I know I can use the “Save to PDF” option within Excel, and achieve the desired results, but when doing so, that process somehow jumbles and shifts around my original tab positions within the Excel workbook.
I have to move them all back to their original locations every time I do a print-to-PDF job.
This could possibly be some setting within Adobe that I am aware of.
Just expressing my situation to the forum in the event others have experienced the same.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
select all the tabs to be printed (click each tab holding CTRL key)
THEN print (or export).
they then print in 1 document.
 
Upvote 0
yes, selecting tabs using your method will export or save as a PDF, however this method repeatedly jumbles my tabs out of their original order.
Printing using Adobe as the printer does not jumble my tabs, however it won't print the whole job without stopping and asking "where to and what name" over and over again...
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top