Hidden Rows in Excel 2007

westrong · 06-26-2009, 08:09 AM

We are experiencing a weird issue in Excel. We have a spreadsheet consisting of approx. 450 rows of data and without warning Excel will compress (or hide) a large group of rows from our view. We starting noticing this after entering data then when going back to edit we find it "missing". When we look at the numbers of rows we may find it to appear something like ..12, 13, 14, 17, 18, 19...etc. Moving the cursor to the 14/17 area will reopen those rows of data but we need that information showing at all times. Also, these missing rows of data will not show up in printed form either.

This problem happens throughout the document and without warning.

OS is Vista.

**macropod** · 06-26-2009, 10:44 PM

hi westrong,

Have you tried repairing Office (Excel Options|Resources|Diagnose)?

westrong · 06-27-2009, 06:45 AM

Thanks, I'll give that a try.

06-26-2009, 08:09 AM	#1 (permalink)
westrong Registered User Join Date: Nov 2008 Posts: 6 OS: XP Home Edition	Hidden Rows in Excel 2007 We are experiencing a weird issue in Excel. We have a spreadsheet consisting of approx. 450 rows of data and without warning Excel will compress (or hide) a large group of rows from our view. We starting noticing this after entering data then when going back to edit we find it "missing". When we look at the numbers of rows we may find it to appear something like ..12, 13, 14, 17, 18, 19...etc. Moving the cursor to the 14/17 area will reopen those rows of data but we need that information showing at all times. Also, these missing rows of data will not show up in printed form either. This problem happens throughout the document and without warning. OS is Vista.

06-26-2009, 10:44 PM	#2 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 549 OS: Vista	Re: Hidden Rows in Excel 2007 hi westrong, Have you tried repairing Office (Excel Options\|Resources\|Diagnose)? __________________ Cheers macropod (MS MVP -Word)

06-27-2009, 06:45 AM	#3 (permalink)
westrong Registered User Join Date: Nov 2008 Posts: 6 OS: XP Home Edition	Re: Hidden Rows in Excel 2007 Thanks, I'll give that a try.