You'll want to do all your page setup and preview within Excel as if you're going to print the file. Once you've done that, PDFMaker will follow the print setup you've established.
This is all assuming you're using Adobe Acrobat and the "Acrobat" toolbar in Excel. If you're doing something different, please let us know the exact process you're using.
Hi Michael, basically when ready I go to save as, select sheet, and save as PDF.
I never noticed the Adobe toolbar in Excel.
Micheal, how can I install the Acrobat toolbar in Excel?
It should get installed automatically if you have an Acrobat version that is compatible with the version of MS Office you have installed. See this page for more information about how to debug problems with the PDFMaker (that's the Acrobat toolbar in e.g. MS Excel or Word): Troubleshoot Acrobat PDFMaker issues in Microsoft Office on Windows