I have tried many methods and Excel 2023 works better by using a formula to convert between Excel and PDF and in some situations you are asked for the page number in the output PDF file. As there is a link from spreadsheet to page number. But the page number in the sheet is not correctly filled in the resulting PDF. Excel to PDF by Example The example works as follows. 1. Select, copy, delete all but two cells and then right click on any blank cell. (If you have multiple sheets, you may have to right-click, copy the selected cells to the clipboard and then right click again after you have copied them) The highlighted cell has formulas =IF(Is(A1>=0 AND A1←8,0,5)) And that formula takes the cell with a value of 8 and converts it to a number (so it returns 2,000,000). What you need to do in Excel 2023 is this: Click the Insert tab Select the cells on the left-hand side of the screen with the formulas and then click Paste. Select cells with functions in the formula to get values For example, in the above example we have a formula =IF(A1>=0 AND A1←8,0,5). In Excel 2010, by clicking the left-click menu on Insert and Select, you can select all selected cells by clicking the 'Select All' button in the middle of the screen and then choosing Paste Selection' from the pop-up menu. Click OK. 2. Copy the first selected cell to the second cell in the spreadsheet Select the first cell by clicking on it and then click on the Conditional Cells (Ctrl+C) Click the file› tab. From the dropdown menu select 'File' and then 'Open'. In the Excel spreadsheet it is usually the last cell marked conditional Cells, click the first cell on line 12, click on the open› button. (You can also edit the spreadsheet in the spreadsheet on line 15 using the options on the right-hand side). 3. Click on the arrow and the format Text to Page Tab and set page to 6 4. Select your preferred font and size and set font color to gray Select all the sheets and click OK 5.