How do I unsquish my Google Docs spreadsheet?
February 5, 2009 11:49 PM   Subscribe

My Google spreadsheet collapsed itself in the middle somehow. How do I get it back?

Here's a screenshot showing that for some odd reason, a worksheet in Google Docs (spreadsheets) jumps from cell 20 to 200 and all my data within the hidden section is gone. I don't know how this happened but I'd like to somehow expand it to restore. How?
posted by mathowie to Computers & Internet (5 answers total) 1 user marked this as a favorite
First, close it and open it again. Problem still there?

If so, select across that range (say from row 19 to 202) and then resize those rows by dragging the edge of one of the labels. They should all resize to the new larger size. Then you can re-adjust as you need to.

Google SS's are kind of flaky sometimes. Too much Javascript trying to run that fancy UI all at once.
posted by rokusan at 11:55 PM on February 5, 2009

If you don't have luck getting the data back within Google Docs itself you could try recover the data by exporting the spreadsheet to another format, then open it in either MS Office or Open Office.

Also, just to confirm, the rows aren't just hidden are they? i.e. Can't you just select both rows 20 and 201, right click and select un-hide rows?
posted by Gomez_in_the_South at 1:04 AM on February 6, 2009

Did you check the revision history?
posted by phatkitten at 6:23 AM on February 6, 2009

Try this: select the two rows that have missing rows between them. In the "Format" menu, select "Row" and then "Unhide."
posted by not that girl at 11:08 AM on February 6, 2009

Oddly, I could never actually fix this, and ended up using safari instead.
posted by mathowie at 7:24 PM on March 8, 2009

« Older Neither a borrower nor a lender be...   |   Quartz floor tiles? Newer »
This thread is closed to new comments.