Forum Discussion

VeraExcel's avatar
VeraExcel
Copper Contributor
Feb 08, 2023

Excel rows disappeared

Hi all, 

 

I have a problem and would love to receive some help! I just deleted some rows in Excel. Since then, my spreadsheet has been drastically reduced. It stops at 88004 rows and won't show any further rows (all other sheets of my Excel file contain the usual row limit of 1.048.576. 
Even if I copy in data from another File in this sheet, it cuts it of at 88.004 and deletes any additional rows. Is there any way to fix this broken sheet or do I have to redo all my analysis and pivots that are based on this.

 

Thanks! 
Vera

 

 

excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Feb 08, 2023

    VeraExcel Select the box with the little triangle at the top left of the grid.

    Right-click on any of the row numbers and select Unhide.

     

     

    • VeraExcel's avatar
      VeraExcel
      Copper Contributor
      Feb 08, 2023

      Hey Riny_van_Eekelen, 

       

      thanks for your response. Unfortunately, this does not change anything in my file. It seems like all rows after 88004 are just gone.  There are no filters set and now rows hidden.

      Best, 
      Vera

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Feb 08, 2023

        VeraExcel I doubt it. You simply can't reduce the number of rows in an Excel sheet.

        Hide them, yes. But you can't delete them.

         

        Please try again. Select the box with the tri-angle in it (above row number 1 and left of column A) to select all cells. Right-click on a row number and then Unhide.

         

Resources