By default, the system will scale each datasheet in the excel file into one page when rendering the PDF of the excel file. When empty cells in an excel file are formatted, such as filled with the background color, with cell boards, resized the row height or column width, etc. they are included in the PDF rendering. This makes the datasheet too big to be scaled into one page. When the file name is clicked to display the PDF preview, there will be a PDF error message that indicates which datasheet caused the PDF issue. Deleting extra cells in the datasheet may solve the issue.
To delete extra rows
1. Find the end of your data in the datasheet, place the mouse on top of the row number a couple row below the data, left click once.
2. Press down the "Shift"+"Ctrl" keys on the keyboard at the same time, and press the down arrow key to select all rows.
3. Place the mouse over the row numbering area, right-click the mouse, and select "Delete" from the list to delete all selected rows.
To Delete Extra Columns
1. Place the mouse on top of the column number that is empty, left click once.
2. Press down the "Shift"+"Ctrl" keys on the keyboard at the same time, and press the right arrow key to select all columns on the right of the data.
3. Place the mouse over the column letter area, right-click the mouse, and select "Delete" from the list to delete all selected columns.