Question: how to convert multiple excel sheets to one pdf files?
Answer: Click Excel Options. Click Entire Workbook or Sheets From a Range. ... 
Click OK. Click Convert to PDF.
Choose The file location and name to save to then click Save. Secondary method: ... 
Click Print. Choose The file location and name to save to then click Save.