In Excel for Windows, choose File → Export → Create PDF/XPS Document → Create PDF/XPS, pick where to save it and click Publish. You can also use Save As and set the file type to PDF. In Excel for Mac, choose File → Save As and set File Format to PDF.
Check File → Print first: the PDF uses the same page settings as printing, so the print preview shows exactly how the PDF will be split into pages.
