Excel blank rows cannot be deleted RRS feed

  • Question

  • There are only tens of rows in Excel, but the entire table does have 100,000+ rows, Ctrl + End and then delete the blank rows, but still can not be solved.
    What is the reason, how to solve?
    Wednesday, June 19, 2019 4:56 AM


  • Hi,

    Could you provide a screenshot about Blanks rows? Did these rows contain in Table?

    Did this problem only appear in a specific file or all Excel files?

    Did you use may custom format for the table? 

    I suggest you try to change the Table to Range and clear the blank rows.

    Please try this method and let me know the result, I'm glad to help you.

    Emi Zhang


    点击了解更多或者访问我们的 专用论坛,与我们的技术专家一起分享探索 Microsoft Office 2019。

    • Marked as answer by 莹子 Thursday, June 20, 2019 12:45 AM
    Wednesday, June 19, 2019 8:21 AM