none
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

Answers

  • 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


    如果以上回复对您有所帮助,建议您将其标记为答复。如果您对我们的论坛支持有任何的建议,可以通过此邮箱联系我们:tnsf@microsoft.com.

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

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