You can automate your entire work from a simple macro. Learn all this useful trick today! Feb 12, 2023 — An interesting method of creating different PDF files is to create one PDF file for each sheet, and just add to it in the same way as you'd add a link to another PDF. To add any cell or number for printing, first find it by using CTRL keys or CMD keys to select it and choose To create PDF from cells. Then just hit the Print button. 1. Select the sheet as you normally would to print a number from the sheet that you chose for printing. 2. Set the PDF option to the second page (and you can use your own choice by clicking the PDF icon) 3. Click the Save as button (or save a link, and then select the PDF file as well), and you will see the following results.