SoldEazy Help and Support

Error: unknown columns in the datasheet

Error: unknown columns in the datasheet
Error: unknown columns in the datasheet

1. Open the Excel file
2. Find the rightmost column (usually DH). Select the blank column on its first right hand-side column (DI according to general case).
Quick way: click cell A1, then press ctrl + right (arrow) on the keyboard. It will jump to DH immediately. Then select column DI.
3. After selecting column DI, press ctrl + shift + right (arrow). At this moment, you will select all cells on the right hand-side. Press delete.
4. Find bottom row.
Quick way: click G1 which is certainly on a continuous column. Press ctrl + down (arrow) on the keyboard. It will jump to the last row immediately. Then select column DI.
5. Select the blank rows lower than the bottom row, press delete.
Quick way: Press ctrl + shift + down (arrow). Then you will select all cells below last row without empty cell. Press bottom delete.
-------------------------------------------------------------------------------
Please create a new xlsx by copying the parts you should upload. And save as a new Excel if the first method doesn’t work.

***Fin***

0 (0)
Article Rating (No Votes)
Rate this article
Attachments
There are no attachments for this article.