none
Excel 2013: Some rows are not displayed in excel RRS feed

  • Question

  • Hi Everyone, 

    I copied data from Excel 2013 file A  to excel 2013 file B, but at File B, some rows are not displayed as the attached picture, meanwhile file A rows are all displayed.  From this attached picture, 186th rows to 188th rows are not seen, they are automatically hide. I need to manually drag these rows to be displayed. Why some rows are automatically hidden in excel 2013?

     

    I deleted the pasted data at File B, and I found that the height of row 2 to row 10 is zero, and they are not seen in the excel. The height of row 1 is set to 116, and height of row 11 is set to 20. 

    Why the height of row 2 to row 10 is become zero and cannot see in the excel file B? 


    May8692


    • Edited by May8692 Wednesday, January 13, 2016 3:17 AM
    Wednesday, January 13, 2016 2:59 AM

Answers

  • Hello May8692,

    This issue might be caused by a lot of reasons. In my view, there might have some unexpected format in the particular files. Please try to clean all the format of the file:

    https://support.office.com/en-us/article/Clean-excess-cell-formatting-on-a-worksheet-e744c248-6925-4e77-9d49-4874f7474738

    If this issue still exists, please try to upload a sample file, we'd like to test it.

    Regards,

    George Zhao
    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
     
    Thursday, January 14, 2016 4:17 AM
    Moderator