Tech Support Forum - View Single Post

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.

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.