How do I unsquish my Google Docs spreadsheet?

February 5, 2009 11:49 PM

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 comments total)

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

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

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

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

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