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 an...
Excel
VeraExcel's avatar
VeraExcel
Copper Contributor

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.

 

  • hilger2000's avatar
    hilger2000
    Copper Contributor
    Nov 07, 2024

    It happened to me.  I deleted all rows from 33 all the way to bottom.  And the rows literally disappeared... not just the contents.  I cannot get to row 33.  Can't unhide.  No filters.

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Nov 08, 2024

      Can only repeat my my previous answer. Can't help unless you share the file.

Resources