Forum Discussion
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?
Device | MacBook Pro |
Processor | 2.4 GHz 8-Core Intel i9 |
Graphics | AMD Radeon Pro 5500M 8 GB Intel UHD Graphics 630 1536 MB |
Memory | 64 GB 2667 MHz DDR4 |
Serial Number | C02CC12KMD6V |
Mac OS | Sonoma Version 14.2.1 |
Storage | 1.5 TB available of 2 TB |
Product Name | Office 365 (EXCEL) |
Version Number | 16.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_EekelenPlatinum 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.
- DWaldenCopper ContributorThanks, 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.