Forum Discussion

DWalden's avatar
DWalden
Copper Contributor
Mar 30, 2024
Solved

Missing row 305 in EXCEL

I noticed that my EXCEL worksheet is missing Row 305, and nothing I tried will bring it back.  So I devised a formula to see what this is about, in the form =A305-A307 for each cell in 475 rows of my worksheet.  The calculated results ought to be constant for the whole range of rows from 3 to 475, but it is not.  Can anyone explain what is going on here?

 

DeviceMacBook Pro
Processor2.4 GHz 8-Core Intel i9
GraphicsAMD Radeon Pro 5500M 8 GB Intel UHD Graphics 630 1536 MB
Memory64 GB 2667 MHz DDR4
Serial NumberC02CC12KMD6V
Mac OSSonoma Version 14.2.1
Storage1.5 TB available of 2 TB
Product NameOffice 365 (EXCEL)
Version Number16.83 Installed March 12 2024

 

Excel File

Point Name Index.xlsx
  • DWalden Select entire rows 304 through 306. Two finger click, Unhide.

    If that doesn't work, choose Row Height and enter a number like 15. Either of these two options should make row 305 visible again.

     

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    DWalden Select entire rows 304 through 306. Two finger click, Unhide.

    If that doesn't work, choose Row Height and enter a number like 15. Either of these two options should make row 305 visible again.

     

    • DWalden's avatar
      DWalden
      Copper Contributor
      Thanks, Riny, that fixed it. For a minute or so, I tried replicating the original problem and failed. I didn't pursue the matter after that.

Resources