You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Arxspan User Guides > Notebook > Delete Extra Cells in Excel to Resolve PDF Error
Delete Extra Cells in Excel to Resolve PDF Error
print icon

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.

Feedback
0 out of 0 found this helpful

scroll to top icon