How to convert multiple Excel sheets into one PDF file. Click the first sheet tab that you want to use. CTRL-click each additional tab to print, or SHIFT-click the last tab, if you want to use all tabs. Click File, Print. Select Microsoft Print to PDF or another PDF printer. Choose to print All Selected Sheets. Choose other options as needed. Click Print. You’ll be prompted for where to save the file, and for what name to give the file. Click Save. When you’re done, RIGHT-click on any of your selected tabs and choose Ungroup Sheets. This is important. If you don’t ungroup them, any change that you make to a cell on one sheet will be made to that cell on all sheets. For example, if the sheets are still grouped, and you change cell C5 on the first sheet, you will have also changed C5 on the other sheets.
This is a quick and dirty way to get a large amount of data stored in Excel. It works with any Excel worksheet that you want to print. Please don’t hesitate to contact me for any questions.