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 how we get around that--using Ungroup Sheets to ungroup sheets with common formatting and contents between them. You’ll find Ungroup Sheets under the Sheets tab. Excel 2003: Ungroup and Ungreampage If you used Excel 2003 and saved each file with its own name (but, in my experience, it is not necessary--a single file name appears to work just fine), then use the new Save As... option to create a new Excel file. However, if you are using a program that automatically creates new or duplicate Excel files based on its open files, then you need not do anything. These programs, like Microsoft Excel, will create new files for you automatically when you run your workbooks again.