Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Saving multiple sheets into 1 pdf form

5,968 views
Skip to first unread message

MCu...@officeformac.com

unread,
Oct 19, 2009, 3:10:44 PM10/19/09
to
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

When I try to save 2 excel sheets (in 1 workbook) into 1 pdf file it saves them individually. Of course my fellow PC user can save the 2 sheets into 1 pdf file (multiple pages) but I cannot seem to figure it out for a MAC. Is it just not an option?
Thank you!!

CyberTaz

unread,
Oct 20, 2009, 12:49:55 PM10/20/09
to
Unfortunately Apple & MS are both saddled with the same Adobe Acrobat
limitations on the Mac, but there is a relatively simple workaround...

Generate the multiple PDFs then open"page 1" in Apples Preview app and
display the Drawer (now called a Sidebar). Bring a Finder window up,
navigate to where the other "pages" are stored & drag them into the Drawer
(you can select & drag more than one at a time). Rearrange if necessary &
SAVE as a single PDF. If you happen to have Acrobat you can combine the PDFs
there as well as with a number of PDF "stitcher" utilities available on the
web � most of which are freeware/shareware.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 10/19/09 3:10 PM, in article 59b7e...@webcrossing.caR9absDaxw,

solomon...@officeformac.com

unread,
Oct 20, 2009, 3:48:05 PM10/20/09
to
have the same problem.

I contacted Adobe and they said that the problem is with the WAY EXCEL SENDS THE WORKSHEETS TO ADOBE ACROBAT. This means that technically the problem is with the way Excel has been designed. i confirmed this for myself when i created another workbook in IWorks' Numbers and it printed the whole worksheet as one pdf file without any problem.

The workaround you've prescribed is TOO LONG A PROCESS WHEN I CAN JUST DO ONE CLICK IN OTHER PRODUCTS AND GET THE RESULT THAT I WANT.

I (AND I'M SURE MANY EXCEL FOR MAC USERS) WILL REALLY APPRECIATE THIS PROBLEM BEING FIXED INSTEAD OF BEING TOLD TO DO A TEN CLICK AND PROCESSES WORKAROUND.

THANK YOU,

CyberTaz

unread,
Oct 20, 2009, 5:01:24 PM10/20/09
to
Perhaps you might like to ask Adobe why they continue to sing the same old
song when Mac Excel sends content in exactly the same manner that PC Excel
does, yet the phenomenon doesn't occur on a PC. While you're at it you might
also ask them why their PDF *printer* can't reproduce in a file what
literally every other printer driver on the planet has no problem with :-)

It might also be interesting to know what Adobe has to say about why the
Acrobat 9 PDF driver *can* avoid multiple PDFs from a single file but the
utility they're offering Apple & MS for use on Macs just doesn't seem to
have the same capabilities... You do realize that virtually *all* PDF
generators are licensed from Adobe, right?

Regards |:>)


Bob Jones
[MVP] Office:Mac


On 10/20/09 3:48 PM, in article 59b7e...@webcrossing.caR9absDaxw,

John McGhie

unread,
Oct 21, 2009, 6:13:54 AM10/21/09
to
Who did you think you are shouting at?

Did you imagine Microsoft or Adobe were reading here? Sorry to burst your
bubble, but there's no-one here but us fellow users.

Some of us have ideas about things we would like the Microsoft Corporation
to do, also. But we don't work there, and we have no say in the matter.

We come in here trying to offer fellow users a way to use the software the
way Microsoft made it. Nobody pays us for this: we are just trying to help
people because it makes us feel good.

At least, it makes us feel good except when ungrateful types shout at us...

On 21/10/09 6:48 AM, in article 59b7e...@webcrossing.caR9absDaxw,
"solomon...@officeformac.com" <solomon...@officeformac.com> wrote:

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:jo...@mcghie.name


jrsem...@officeformac.com

unread,
Oct 21, 2009, 6:53:51 PM10/21/09
to
Thank you for this post. I am sturggling with the SAVE AS A SINGLE PDF part. While i can get all the pdfs in the "Sidebar" when i save it only saves the pdf I am viewing even when i choose Save As...Help please!

> Unfortunately Apple & MS are both saddled with the same Adobe Acrobat
> limitations on the Mac, but there is a relatively simple workaround...
>
> Generate the multiple PDFs then open"page 1" in Apples Preview app and
> display the Drawer (now called a Sidebar). Bring a Finder window up,
> navigate to where the other "pages" are stored & drag them into the Drawer
> (you can select & drag more than one at a time). Rearrange if necessary &
> SAVE as a single PDF. If you happen to have Acrobat you can combine the PDFs
> there as well as with a number of PDF "stitcher" utilities available on the

> web &#65533; most of which are freeware/shareware.
>
> HTH |:>)


> Bob Jones
> [MVP] Office:Mac
>
>
>

> On 10/19/09 3:10 PM, in article 59b7e...@webcrossing.caR9absDaxw,

CyberTaz

unread,
Oct 22, 2009, 9:44:48 AM10/22/09
to
Yeah, I guess I didn't give you enough detail :-) Although I'm using Preview
5.0 in Snow Leopard IIRC this will also do the job in 4.x...

Select an item in the Sidebar, then Command+A to Select All
Use File> Print Selected Pages
Hit the PDF button in the Print dialog & select Save As PDF (or whatever) &
go from there.

--
Regards |:>)


Bob Jones
[MVP] Office:Mac

<jrsem...@officeformac.com> wrote in message
news:59b7e...@webcrossing.caR9absDaxw...

jrsem...@officeformac.com

unread,
Oct 22, 2009, 7:01:47 PM10/22/09
to
Worked like a charm - many thanks! The trick for me was "printing" as pdf in preview not "saving".

> Yeah, I guess I didn't give you enough detail :-) Although I'm using Preview
> 5.0 in Snow Leopard IIRC this will also do the job in 4.x...
>
> Select an item in the Sidebar, then Command+A to Select All
> Use File> Print Selected Pages
> Hit the PDF button in the Print dialog & select Save As PDF (or whatever) &
> go from there.
>
> --
> Regards |:>)
> Bob Jones
> [MVP] Office:Mac
>

> wrote in message
> news:59b7e...@webcrossing.caR9absDaxw...
> > Thank you for this post. I am sturggling with the SAVE AS A SINGLE PDF
> > part. While i can get all the pdfs in the "Sidebar" when i save it only
> > saves the pdf I am viewing even when i choose Save As...Help please!
> >
> >> Unfortunately Apple & MS are both saddled with the same Adobe Acrobat
> >> limitations on the Mac, but there is a relatively simple workaround...
> >>
> >> Generate the multiple PDFs then open"page 1" in Apples Preview app and
> >> display the Drawer (now called a Sidebar). Bring a Finder window up,
> >> navigate to where the other "pages" are stored & drag them into the
> >> Drawer
> >> (you can select & drag more than one at a time). Rearrange if necessary &
> >> SAVE as a single PDF. If you happen to have Acrobat you can combine the
> >> PDFs
> >> there as well as with a number of PDF "stitcher" utilities available on
> >> the
> >> web &#65533; most of which are freeware/shareware.
> >>
> >> HTH |:>)
> >> Bob Jones
> >> [MVP] Office:Mac
> >>
> >>
> >>
> >> On 10/19/09 3:10 PM, in article 59b7e...@webcrossing.caR9absDaxw,
> >> "MCu...@officeformac.com" wrote:
> >>

CyberTaz

unread,
Oct 23, 2009, 6:08:23 AM10/23/09
to
No Problem -- sorry not to have been more clear to begin with :-}

Regards |:>)
Bob Jones
[MVP] Office:Mac

On 10/22/09 7:01 PM, in article 59b7e...@webcrossing.caR9absDaxw,

wdkst...@gmail.com

unread,
Jun 28, 2012, 11:17:50 AM6/28/12
to
2.5 years later and the problem is still there for Excel 2011 and the PDF printer. I am not so sure I ascribe to the Adobe conspiracy theory, but what do I know - I'm just a user. Maybe I should try the Mac workbook... at least for PDF printing, which I have to do all the time. OR... any updates on more efficient workarounds??? My workbooks have many pages, and dragging them all into preview frequently rearranges the pages.

Richard H

unread,
Jun 30, 2012, 5:29:44 AM6/30/12
to
On 28/06/2012 4:17 pm, in article
5a94ad4c-be02-460d...@googlegroups.com,
I use Combine PDFs:

<http://download.cnet.com/Combine-PDFs/3000-2193_4-41822.html>
--
Please reply via Newsgroup


spsn...@gmail.com

unread,
Nov 27, 2012, 3:35:48 PM11/27/12
to
If anyone from Microsoft does read this, please be aware that those of us who support printers get calls about this all the time, and there isn't a thing we can do about it, because Excel jobs are separated by the sheet. Under Windows, page setup applies only to the individual spreadsheet, rather than to the entire workbook. On the Mac side, it sends jobs separately, which makes it impossible to do stapled/duplexed sets without some complex workarounds.

I'll never know why Microsoft hasn't fixed this; it's been an issue for us for at least 10 years, and it has resulted in some furious customers.

murray...@googlemail.com

unread,
Oct 18, 2013, 5:06:01 AM10/18/13
to
Word is broken. Libre office handles this just fine.

murray...@googlemail.com

unread,
Oct 18, 2013, 5:11:17 AM10/18/13
to
On Tuesday, October 20, 2009 10:01:24 PM UTC+1, CyberTaz wrote:
> Perhaps you might like to ask Adobe why they continue to sing the same old
> song

You might want to ask Microsoft why they sing the same old song too... There are no innocents in the software industry, only the guilty.

Regards |:>)

Murray Elliot
IT professional for 30 years

mgsh...@gmail.com

unread,
Feb 27, 2014, 3:02:18 AM2/27/14
to
Thanks Cyber Taz, magic.

However what I did was:

- Command+A to Select All
- Tick Scaling Fit to " 1 "
- Bottom left corner, save as PDF

Im assuming I could also PRINT in one page and look tech smart, rather than the norm
of chopping up my 1 page work in half and look suspicious :-D !

Thank you!

rinni...@gmail.com

unread,
Mar 3, 2014, 9:06:06 PM3/3/14
to
Hi,
I'm no expert but this seems to work for me. I select the tabs I want, then click on print preview. The file will show up in pdf then I save a copy of it. Keep in mind, acrobat is my default application for print preview, instead of "Preview" app. Hope it works for you :)

zoe...@gmail.com

unread,
Sep 7, 2016, 12:03:30 AM9/7/16
to
You might like to check out best excel to pdf converter for xp on online too. We like to think it’s got some pretty neat best excel to pdf converter for xp on online tools.http://www.pdfcoding.com/online/pdf/convert-excel-to-pdf/.

anis...@northern.co

unread,
May 9, 2018, 3:04:10 PM5/9/18
to
I have Yosemite OSX and would like to download 20+tabs of worksheets as PDFs. Is there a way to do this quickly without having to open each tab and Download As > PDF ???

Let me know!
0 new messages