I’ve got eight Excel sheets that need to become one PDF under 10 MB for a portal. Printing them separately just left me with a pile of files. Anyone know how?
In Excel go File > Save As > PDF, then under Options pick “Entire workbook” so all sheets combine into one file. Not sure if it’s the same on Mac.
I had this with tenant forms. I print the Excel sheets to PDF, then use the print dialog’s “Save as PDF” on the combined file with lower quality if it offers that. Check the pages after, since small text can get hard to read.