Okay, I'm actually trying to so this in Excel 2003 for Windows at work, but I have the most recent version of Office for Mac on my home computer and can do it there if the procedure is different between the two versions.
I'm working on a certain type of project that can have any combination of associated Word, PowerPoint, and Excel documents. When I'm done with a project, I want to create a single PDF containing all associated content. In principle, it's easy: create a PDF of each document, and then combine the PDFs using Acrobat. Unfortunately, most of the Excel spreadsheets are wider than any of the paper sizes in Excel's Page Setup options. For instance, if I select Legal for the paper size and then print landscape to PDF, it prints however many columns would fit on an 11" piece of paper, then prints the next 11" range of columns, and so on. The resulting document makes no sense, because all the columns aren't contiguous. I'm never going to print the PDF, just view it on screen, and I want the PDF to look just like the Excel spreadsheet does. Is there any sort of "Print Actual Width" option in Acrobat that overrides Excel's page-size options? I've Googled this topic and checked Microsoft's support site, and haven't seen anyone else ask the question.
I'm working on a certain type of project that can have any combination of associated Word, PowerPoint, and Excel documents. When I'm done with a project, I want to create a single PDF containing all associated content. In principle, it's easy: create a PDF of each document, and then combine the PDFs using Acrobat. Unfortunately, most of the Excel spreadsheets are wider than any of the paper sizes in Excel's Page Setup options. For instance, if I select Legal for the paper size and then print landscape to PDF, it prints however many columns would fit on an 11" piece of paper, then prints the next 11" range of columns, and so on. The resulting document makes no sense, because all the columns aren't contiguous. I'm never going to print the PDF, just view it on screen, and I want the PDF to look just like the Excel spreadsheet does. Is there any sort of "Print Actual Width" option in Acrobat that overrides Excel's page-size options? I've Googled this topic and checked Microsoft's support site, and haven't seen anyone else ask the question.