Why does my excel document have 960,000 empty rows?

Posted by C-dizzle on Super User See other posts from Super User or by C-dizzle
Published on 2012-06-05T13:28:48Z Indexed on 2012/06/07 4:43 UTC
Read the original article Hit count: 252

I have an excel document, Office 2007, on a Windows 7 machine (if that part matters any, I'm not sure but just throwing it out there). It is a list of all employee phone numbers. If I need to generate a new page, I can click on page 2 and the table will automatically generate again.

The problem is, someone messed it up since it's on a network drive and now shows I have over 960,000 rows of data, when I really don't! I did CTRL+END to see if any data was in the last cell, so I cleared it out, deleted that row and column, but still didn't fix it. It almost seems like it duplicates itself after the deletion.

How can I fix this instead of recreating the entire document?

© Super User or respective owner

Related posts about windows-7

Related posts about microsoft-excel