How to print multiple Excel sheets into a single PDF file?

"I tried multiple times to give the two separate sheets the same page margins and page properties, but it didn't help me one bit.

I fixed this with an Automator task that took me quite a while to work out, but once it worked, it helped me a lot.

Thanks for all the answers, though I really did specify in my question that I did do all the suggested solutions before posting."

Select the sheets you want in your pdf file (make sure you print preview / set print areas in each sheet that you want to print) and "save as" pdf. Makes a pdf file with all selected worksheets.

"Is there any kind of ""options"" button in the Save As dialogue?
On Excel 2007 / Windows the Save As pdf dialogue has an options button which then allows you to save only the selection, the active sheet, the selected sheets, the whole workbook etc.
I have no idea if this is available on your version of Office for Mac."
"Is there any kind of ""options"" button in the Save As dialogue?
On Excel 2007 / Windows the Save As pdf dialogue has an options button which then allows you to save only the selection, the active sheet, the selected sheets, the whole workbook etc.
I have no idea if this is available on your version of Office for Mac."

"When saving the doc, selection option and all workbook instead of active sheet

Select and Drag all the PDFs into preview.
Select all in sidebar.
Print and Save As PDF."