How can I delete empty rows in my Excel file to upload it to Labregister?

Modified on Wed, 06 Jul 2022 at 04:09 PM

One very frequent issue, when uploading an Excel file to Labregister, is empty rows at the bottom of an inventory list in Excel which leads to an error message.


Note: As long as empty rows are at the end of an Excel file the import to Labregister will not be successful.


To be able to solve this issue, please follow the steps below:

  1. Within the original Excel file, scroll down to the last row.
  2. Select the first empty row.
  3. Press Ctrl + Shift + downwards arrow to highlight all empty rows in the sheet.
  4. Right-click the selected rows and select Remove.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article